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 can I make PL/SQL Developer display the number of rows returned by a query?

User_ZR3PEDec 16 2022

How can I make PL/SQL Developer display the number of rows returned by a query without fetching last page? Because fetching last page takes too much time in big tables. Let say I write a query and I expect around 3 millions rows as result, for that reason I must know how many rows returned result of that query before exporting as csv file. I googled it but I get the results for options settings of SQL Developer not PL/SQL Developer, or some people suggested change "Records Per Page" settings to "All records" .
Adsız.png

This post has been answered by BluShadow on Dec 16 2022
Jump to Answer
Comments
Post Details
Added on Dec 16 2022
4 comments
3,307 views