The ROWNUM is a pseudo column in Oracle SQL / PLSQL which returns a row’s position in the fetched result set. ROWNUM is evaluated AFTER records are SELECTED from the data-base and BEFORE execution of the ORDER BY clause. Syntax for the ROWNUM function in Oracle SQL / PLSQL is: SELECT column(s) FROM table_name WHERE […]