About ‘ROWNUM’ in Oracle
ROWNUM is an Oracle pseudo column which numbers the rows in a result set. SELECT rownum, table_name FROM user_tables; ROWNUM TABLE_NAME ————- —————– 1 EMP 2 DEPT 3 BONUS 4 SALGRADE 5 DUMMY 5 rows selected Here is a summary of how ROWNUM can be used. Limiting Rows ROWNUM can be used to limit the … [Read more…]