Tag Archives: new features

PL/SQL New Features in Oracle Database 12c

I recently put some more PL/SQL new features articles live. PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1) Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1) Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1) I’ve also posted a top-level new features […]

11g bits and bobs…

I’ve just released an article covering the Miscellaneous New Features section of the OCP upgrade exam. It contains a rather random assortment of stuff including: Online Table Redefinition Enhancements Enhanced Finer Grained Dependency Management DDL With the WAIT Option (DDL_LOCK_TIMEOUT) Invisible Indexes Query Result Cache Adaptive Cursor Sharing Temporary Tablespace Enhancements I was toying with […]

PL/SQL updates in Oracle 11g

On the surface, the changes to PL/SQL look rather minor, but there is some seriously cool stuff in there. I originally intended to write a single article, but some sections got too big so I thought it was worth sectioning them out into separate articles. PL/SQL New Features and Enhancements in Oracle Database 11g Release […]