Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Holding variable of rows returned.

706488Jun 15 2009 — edited Jun 15 2009

Hi pals,
I've seen when I make a query in Oracle at the end of the rows returned appears one leyend that says :
*"60 rows selected"*
I wondering if there exist a system variable that holds the value of the rows returned in this case one variable that holds "60" .
I know that rownum holds the value for each record returned but that's not that i want.

Does exist a method that return me only the number of that leyend?

Edit:
All this in SQL-PLUS
Edited by: Mariots on 15/06/2009 12:31 PM

Edited by: Mariots on 15/06/2009 12:32 PM

Edited by: Mariots on 15/06/2009 12:32 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2009

Added on Jun 15 2009

#general-database-discussions

11 comments

457 views