The new PL/SQL features for 11g Release
1. Enhancements to Regular Expression Built-in SQL Functions
2. SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types
3. CONTINUE Statement
4. Sequences in PL/SQL Expressions
5. Dynamic SQL Enhancements
6. Named and Mixed Notation in PL/SQL Subprogram Invocations
7. PL/SQL Function Result Cache
8. Compound Triggers
9. More Control Over Triggers
10. Database Resident Connection Pool
11. Automatic Subprogram Inlining
12. PL/Scope
13. PL/SQL Hierarchical Profiler
14. PL/SQL Native Compiler Generates Native Code Directly
See Also:
■ Oracle Database Advanced Application Developer's Guide for
information about the implementation of regular expressions
■ Oracle Database SQL Language Reference for detailed descriptions of
the REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_COUNT
functions
SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types
1. Enhancements to Regular Expression Built-in SQL Functions
2. SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types
3. CONTINUE Statement
4. Sequences in PL/SQL Expressions
5. Dynamic SQL Enhancements
6. Named and Mixed Notation in PL/SQL Subprogram Invocations
7. PL/SQL Function Result Cache
8. Compound Triggers
9. More Control Over Triggers
10. Database Resident Connection Pool
11. Automatic Subprogram Inlining
12. PL/Scope
13. PL/SQL Hierarchical Profiler
14. PL/SQL Native Compiler Generates Native Code Directly
Enhancements to Regular Expression Built-in SQL Functions
The regular expression built-in functions REGEXP_INSTR and REGEXP_SUBSTR have
increased functionality. A new regular expression built-in function, REGEXP_COUNT,
returns the number of times a pattern appears in a string. These functions act the same
in SQL and PL/SQL.
increased functionality. A new regular expression built-in function, REGEXP_COUNT,
returns the number of times a pattern appears in a string. These functions act the same
in SQL and PL/SQL.
See Also:
■ Oracle Database Advanced Application Developer's Guide for
information about the implementation of regular expressions
■ Oracle Database SQL Language Reference for detailed descriptions of
the REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_COUNT
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.
SIMPLE_INTEGER differs significantly from PLS_INTEGER in its overflow semantics,
but SIMPLE_FLOAT and SIMPLE_DOUBLE are identical to their base types, except for
their NOT NULL constraint.
You can use SIMPLE_INTEGER when the value will never be NULL and overflow
checking is unnecessary. You can use SIMPLE_FLOAT and SIMPLE_DOUBLE when the
value will never be NULL. Without the overhead of checking for nullness and overflow,
these subtypes provide significantly better performance than their base types when
PLSQL_CODE_TYPE='NATIVE', because arithmetic operations on SIMPLE_INTEGER
values are done directly in the hardware. When PLSQL_CODE_
TYPE='INTERPRETED', the performance improvement is smaller.
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.
SIMPLE_INTEGER differs significantly from PLS_INTEGER in its overflow semantics,
but SIMPLE_FLOAT and SIMPLE_DOUBLE are identical to their base types, except for
their NOT NULL constraint.
You can use SIMPLE_INTEGER when the value will never be NULL and overflow
checking is unnecessary. You can use SIMPLE_FLOAT and SIMPLE_DOUBLE when the
value will never be NULL. Without the overhead of checking for nullness and overflow,
these subtypes provide significantly better performance than their base types when
PLSQL_CODE_TYPE='NATIVE', because arithmetic operations on SIMPLE_INTEGER
values are done directly in the hardware. When PLSQL_CODE_
TYPE='INTERPRETED', the performance improvement is smaller.
0 Comments