Total Pageviews

May 24, 2017

5/24/2017 07:44:00 AM

Oracle 12 c features

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

 
Related Posts Plugin for WordPress, Blogger...