Question: How can I make SQL Developer display the number of rows returned by a query?
Answer: Execute the query, and fetch all the rows.
But I’m not seeing it!
and fetch all the rows.
This part is important.
Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records.
Warning: Rant ahead!
…Until All Rows Are Read – there’s one or more proceses on the server WAITING for you
So close these grids. Or read all the rows. Then you don’t have to worry about upsetting the DBA because you’re wasting server resources.
This becomes especially important if you enable the ‘More Grids’ preference.
Close when finished 🙂