Technical Notes
We're all on the same page!
Showing posts with label
rownum
.
Show all posts
Showing posts with label
rownum
.
Show all posts
Wednesday, 12 April 2017
How to see TOP 10 SQL that consuming system resources highly?
›
e.g. select * from ( select * from v$sql order by DISK_READS desc ) where rownum < 11 options for order by: RUNTIME_MEM, EXEC...
Saturday, 11 October 2014
How to select top 10 records in Oracle 11g and 12c?
›
In 11g: As you now that TOP keyword does not exist in 11g, but you can use rownum keyword to query top records. For example, you want t...
›
Home
View web version
