Skip to Main Content

SQL & PL/SQL

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!

How to get the total count of the no. or rows a cursor has fetched

673860Jun 10 2011 — edited Jun 16 2011
Hi All,

Is there a way to get the number of rows a cursor query has fetched, without looping into the cursor and using a counter variable

I mean like in pl/sql table we can directly use the pl/sql table attribute .count is there a way to achieve this in cursor

thanks a lot in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2011
Added on Jun 10 2011
8 comments
4,562 views