Oracle SQL : 12 c Features -First Rows/OFFSET
Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we could add something like the following to our query
...
AND ROWNUM <= 5;
SELECT * FROM emp
FETCH FIRST 10 ROWS ONLY;
OFFSET:
select * from emp
FETCH FIRST 2 PERCENT ROWS ONLY
select * from oe_order_headers_all
OFFSET 60 ROWS FETCH FIRST 5 ROWS ONLY;
For more Oracle 12c Features
New Features --1
Identity Column
