Database Reference
In-Depth Information
Figure 24.22
Demonstrating the
Use of the NULL
Command.
24.9
Oracle-Provided Packages
Oracle Database provides access to an enormous number of extra and
optional features. Many of these features are provided by add-on packaged
PL/SQL routines. A scant few of the more interesting and general-use pack-
ages are described as follows:
DBMS_REDEFINITION
. Online redefinition of tables.
DBMS_LOB
. Manipulate LOB objects.
DBMS_OUTPUT
. Can be used to produce output from PL/SQL
blocks; often used for debugging.
DBMS_SQL
. Allows for coding of dynamically generated SQL code,
superseded by the EXECUTE IMMEDIATE command.
UTL_FILE
. Output to files in the operating system from Oracle
Database.
UTL_HTTP
. Similar type of function to UTL_FILE, except calls
over an HTTP protocol from SQL and PL/SQL.
DBMS_PIPE
. A pipe permits interprocess communication, in the
case of Oracle Database intersession communication.
DBMS_JOB
. Scheduling of jobs.
