OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » number of record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

number of record [message #623746]

Sat, 13 September 2014 23:45

hahaie
Messages: 194
Registered: May 2014

Senior Member

Is there any way of knowing the number of records returned from a query?

Report message to a moderator

Re: number of record [message #623748 is a reply to message #623746]

Sun, 14 September 2014 00:40

Littlefoot
Messages: 21757
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sure.

select count(*)
from (your query goes here);

Or, in PL/SQL, you could use SQL%ROWCOUNT.

Or, in Reports, create a summary column based on the COUNT function.

Or, in Forms, use COUNT_HITS.

Is that enough?

Report message to a moderator

Re: number of record [message #623752 is a reply to message #623748]

Sun, 14 September 2014 01:44

hahaie
Messages: 194
Registered: May 2014

Senior Member

Why do I think?!!!
In my mind was a SRW functions....

Report message to a moderator

Re: number of record [message #623769 is a reply to message #623752]

Sun, 14 September 2014 06:05

hahaie
Messages: 194
Registered: May 2014

Senior Member

In this case::""Or, in Reports, create a summary column based on the COUNT function.""
"Reset As" property,What is equal?report or page?
i think no report and no page.Because this function must be calculated for every master.

Report message to a moderator

Re: number of record [message #623783 is a reply to message #623769]

Sun, 14 September 2014 13:25

Littlefoot
Messages: 21757
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So reset it at desired (master) group.

Report message to a moderator

Previous Topic:	do not show details of detail Query
Next Topic:	set format trigger=return(false) for a parent frame

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 02 16:14:37 CST 2023