The new PL/SQL features for 11g Release 1 (11.1) are:
■ Enhancements to Regular Expression Built-in SQL Functions
■ SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types
The SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE data types are
predefined subtypes of PLS_INTEGER, BINARY_FLOAT, and BINARY_DOUBLE,
respectively. Each subtype has the same range as its base type and has a NOT NULL constraint.
■ CONTINUE Statement
The CONTINUE statement exits the current iteration of a loop and transfers control to
the next iteration (in contrast with the EXIT statement, which exits a loop and
transfers control to the end of the loop). The CONTINUE statement has two forms: the
unconditional CONTINUE and the conditional CONTINUE WHEN.
■ Sequences in PL/SQL Expressions
The pseudocolumns CURRVAL and NEXTVAL make writing PL/SQL source code easier
for you and improve run-time performance and scalability. You can use sequence_
name.CURRVAL and sequence_name.NEXTVAL wherever you can use a NUMBER
expression
■ Dynamic SQL Enhancements
Native dynamic SQL now supports a dynamic SQL statement larger than 32 KB by
allowing it to be a CLOB
■ Named and Mixed Notation in PL/SQL Subprogram Invocations
■ PL/SQL Function Result Cache
■ Compound Triggers
■ More Control Over Triggers
The SQL statement CREATE TRIGGER now supports ENABLE, DISABLE, and FOLLOWS
clauses that give you more control over triggers. The DISABLE clause lets you to create a
trigger in the disabled state. This helps one to create a trigger successfully before you enable the trigger. The ENABLE clause explicitly specifies the default state. The FOLLOWS clause lets you control the firing order of triggers that are defined on the same table and have the same timing point.
■ Database Resident Connection Pool
■ Automatic Subprogram Inlining
■ PL/Scope
■ PL/SQL Hierarchical Profiler
■ PL/SQL Native Compiler Generates Native Code Directly
