Bulk Bind Improvements


Page 162

Oracle Database 10g comes with a number of new features that are designed to provide enhanced application development functionality within the Oracle database. This chapter covers the following topics related to these new features:

image Bulk bind improvements

image Collection set operations

image Database storage of natively compiled PL/SQL

image PL/SQL fine-grained debug privileges

image PL/SQL regular expressions

image User-specified quote character assignment

image The new utl_compress package

image The new utl_mail package

image PL/SQL compile-time warnings

image New PL/SQL compiler

image Improvements to the dbms_profiler procedure

image Table function enhancements

Bulk Bind Improvements

Bulk bind operations help to improve the performance of PL/SQL operations. Oracle Database 10g offers new functionality associated with bulk binds, including:

image Processing of sparse collections

image New exception handling

Processing Sparse Collections

Prior to Oracle Database 10g, processing of collections that contained sparse element collections was inefficient. If the save exceptions clause was not specified, then the statement being executed would terminate when it reached the first deleted element. When save exceptions was used, the operation would not fail, but if there were a number of deleted elements, the performance of the process was much worse than it would have been if save exceptions had not been used.


Oracle Database 10g New Features
Oracle Database 10g New Features (Osborne ORACLE Press Series)
ISBN: 0072229470
EAN: 2147483647
Year: 2006
Pages: 80

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net