Skip to Main Content

SQL Developer

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!

Number of Rows Returned By a Query

ben-from-canberraApr 22 2024 — edited Apr 22 2024

I use Dbeaver at work, and it returns the number of total rows return in a query which is very handy.

I am trying to achieve the same result Jeff's instruction on how to do the same in SQL Developer.

The only way I have found is to run the script and get the first 50 rows, then click on the result grid, then press ctrl + End to get the total number of rows? Is this what Jeff is saying in the article or is there a faster way involving less steps?

Is there an option in the preference where we can change the number of rows returned when we run the script from 50 to 10,000 for example?

Comments
Post Details
Added on Apr 22 2024
6 comments
538 views