New Features in Oracle 10g R2
Conditional Compilation
Dynamic Wrap
- DBMS_DDL wrap subprograms hide pl/sql code
PLS_INTEGER
Improved Performance
- The
The new datatypes
Conditional Compilation
Dynamic Wrap
- DBMS_DDL wrap subprograms hide pl/sql code
PLS_INTEGER
Improved Performance
- The
FORALL statement can handle associative arrays and nested tables with deleted elements. You can now use this performance construct in more situations than before, and avoid the need to copy elements from one collection to another.The new datatypes
BINARY_FLOAT and BINARY_DOUBLE can improve performance in number-crunching applications, such as processing scientific data.Regular Expressions
UNIX-style regular expressions. You use the REGEXP_LIKE operator in SQL queries, and the REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR functions anywhere you would use INSTR, REPLACE, and SUBSTR.
Flashback Query Functions
Quoting Mechanism for String Literals
Instead of doubling each single quote inside a string literal, you can specify your own delimiter character for the literal, and then use single quotes inside the string.
Comments