Biju

Oracle Database 12c now includes a row_limiting_clause in the SELECT statement. This new clause limits the rows returned in a more meaningful and effective way, compared to the methods available in previous releases [using ROWNUM or using Top-N rows using subqueries or using analytic functions like RANK or DENSE_RANK]. The syntax for the new clause … Read more

Thought of sharing few good links I came across on Oracle Database 12c. Cloud Database Plug into the Cloud with Oracle Database 12c Oracle Multitenant Upgrade, Migrate and Consolidate to Oracle Database 12c Tuning and Optimizer:  What to expect from the Optimizer with Oracle Database 12c(PDF) SQL Plan Management with Oracle Database 12c (PDF) Understanding Optimizer … Read more