Database Reference
In-Depth Information
Extensive collection set operation capability encapsulates collection
testing and verification coding into single commands. See the previ-
ous section on Oracle SQL improvements in Oracle Database 10
g
.
The PLSQL_WARNINGS database configuration parameter or the
DBMS_WARNINGS package can be used to enable or disable PL/
SQL compilation warnings.
PL/SQL quoting of strings within strings no longer requires the use
of multiple sets of single quotation marks. A string delimiter charac-
ter can now be specified.
The collection iteration FORALL statement is improved.
SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN functions
can help with setting up flashback queries.
The packages UTL_COMPRESS and UTL_MAIL are new. The
UTL_COMPRESS package allows data compression. The UTL_MAIL
package simplifies e-mail from within PL/SQL, where underlying pro-
tocol detail is not required.
2.1.2.1
Java Improvements in Oracle Database 10
g
The Oracle Database kernel JVM is improved in Oracle Database 10
g
for
compliance with the latest version of Java, driver enhancements, connection
caching, and passing of parameters by name for PL/SQL, among various
other improvements. A discussion of the Oracle kernel JVM is a topic in
itself that is beyond the scope of this topic.
2.1.3
XML Improvements in Oracle Database 10g
New operators can be used to convert between XML and SQL, allowing
creation of highly complex XML object document structures, and storage
of those XML documents. See the later section on Oracle SQL improve-
ments in Oracle Database 9
i
for a synopsis of XML functionality. Using
XML in Oracle SQL is covered in detail in Chapter 17.
2.1.4
Some Utility Improvements in Oracle
Database 10g
SQL*Plus:
The SPOOL [CREATE | REPLACE | APPEND] options
enhance the SPOOL command in SQL*Plus.
