Oracle: a quick way to get number of rows using sqlplus
There are times when we need to do some quick test to see if the select query that we build returns reasonable results, here’s a quick solution, type the following into the sql console:
select count(*) from ( select… )
The select… is the query being tested. This is useful when the number of rows returned by select… is huge.