Total Pageviews

October 7, 2016

10/07/2016 04:06:00 AM
Oracle 12c featuresOracle 12c features

1. Multiple indexes on the same column :Before Oracle Database 12c, we could not have multiple indexes on a single column.. But, only one index will be used at a given time.


2) Top-N feature A Top-N query is used to retrieve the top or bottom N rows from an ordered set. Combining two Top-N queries gives you the ability to page through an ordered set 

SQL> SELECT value 
      FROM XXTAB 
  ORDER BY value DESC 
  FETCH FIRST 10 ROWS ONLY; 

3)Cascade for TRUNCATE and EXCHANGE partition. With Oracle Database 12c, 
The TRUNCATE can be executed with CASCADE option which will also delete the child records.

4)Compound Triggers: A compound trigger is actually four different triggers defined as one. it not only it saves lot of code writing, but also resolves the issue where same set of session variables share common data

5). Read Only Tables: In Oracle 11g, a table can be set READ ONLY mode to restrict write operations on the table. A table can be altered to toggle over READ ONLY and READ WRITE modes.

6) Deprecation of SQL Plus: Oracle has deprecated the use of SQL Plus (isqlplus and sqlplusw) since Oracle 11g. Oracle 11g supports SQL plus through command line and recommends the use of SQL Developer.