Monthly Archives: April 2014

TOP N and Pagination in Oracle 12c

Other than Oracle, most of OLTP Databases already had set of SQL syntax for fetching Top N. In Oracle Database 12c includes support for the ANSI-standard FETCH FIRST/NEXT and OFFSET clauses—together called the row limiting clause. Syntax for the same … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , , | 3 Comments

Online Statistics Gathering in Oracle 12c

Online Statistics Gathering, As name implies in oracle we can get Stats automatically Gathered on a object while object is getting created in schema. For online stats , Oracle Carry on Data which were scan\access during Data load in case of … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , | Leave a comment