Introduction PL/SQL New Features in Oracle 11g

Oracle 11g has introduced a number of new features and improvements for PL/SQL. This introduction briefly describes features not covered in this book and points you to specific chapters for features that are within scope of this book. The list of features described here is also available in the “What’s New in PL/SQL?” section of the PL/SQL Language Reference manual offered as part of Oracle help available online.

The new PL/SQL features and enhancements are as follows:

• Enhancements to regular expression built-in SQL functions

• SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE datatypes

• CONTINUE statement

• Sequences in PL/SQL expressions

• Dynamic SQL enhancements

• Named and mixed notation in ...

Get Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.