Database Reference
In-Depth Information
CASE statement expression, as already mentioned.
Performance is improved by native PL/SQL code compilation as
opposed to direct interpretation.
Temporary tables and cursors are no longer required to pass struc-
tured expressions between functions. Now a query can be executed
against a returned set of rows.
Bulk SQL operations can be executed using the EXECUTE IMME-
DIATE command.
Note:
Some Oracle Database l0g items listed in this chapter are not covered
in other chapters of this topic. Some things are too obscure. Any omissions
are deliberate. Details can be found in Oracle documentation.
The next chapter introduces the basics of Oracle Database physical
architecture. A general understanding of underlying architecture is essential
to a thorough understanding of Oracle SQL.
