What’s New in PL/SQL in Oracle Database 10g?
February 9, 2004
Harry Conway
From the Oracle Technology Network
OTN
just announced that PL/SQL runs faster. Twice as fast as 9i and
three times faster than 8i on average. This performance benefit
requires no coding changes!
Get the "PL/SQL Just Got Faster" White Paper from OTN
According to OTN "Oracle
Database 10g also introduces some new PL/SQL language features"
- the binary_float and binary_double
datatypes (the IEEE datatypes).
- the regexp_like, regexp_instr,
regexp_substr and regexp_replace builtins to support
regular expression manipulation with standard POSIX syntax.
- multiset operations on nested table instances
supporting operations like equals, union, intersect,
except, member, and so on.
- the user-defined quote character.
- indices of and values of syntax
for forall.
- the distinction between binary_integer
and pls_integer vanishes.
Oracle Database 10g offers
some new supplied PL/SQL packages. A new package
Utl_Mail makes it possible for a PL/SQL programmer to send
programmatically composed emails.
Utl_Mail is much simpler to use
Utl_Smtp. Another new Package Utl_Compress delivers
the functionality of the zip and unzip utilities in a PL/SQL
environment. A third package Dbms_Warning, allows
the PL/SQL programmer fine grained control over which categories of
warning and which individual warnings to disable, to enable, or to
treat as errors.
|
