Oracle supplied 34 PL/SQL packages with version 7.3.4 of the database
and this grew to an astonishing 287 packages in Oracle 9.2. This
increase indicates that the number of new database features being
supplied in PL/SQL packages has grown tremendously.
The table below lists the supplied Oracle packages, a brief description,
and the version of Oracle that first made it available. Version 7.3.4 is
the oldest included in this book, even though the package may have been
available before 7.3.4.
|
Package
|
Description |
First Available |
|
dbms_alert |
Asynchronous
event notification |
(7.3.4) |
|
dbms_application_info |
Application
registration |
(7.3.4) |
|
dbms_apply_adm |
Streams Apply
Process Administration |
9.2 |
|
dbms_aq |
Advanced Queue
Manipulation |
8.0 |
|
dbms_aqadm |
Advanced
Queueing Administration |
8.0 |
|
dbms_aqelm |
Advanced
Queueing Asynchronous Notification Administration |
9.0.1 |
|
dbms_capture_adm |
Streams Capture
Process Administration |
9.2 |
|
dbms_cdc_publish |
Change Data
Capture Publishing Routines |
9.0.1 |
|
dbms_cdc_subscribe |
Change Data
Capture Subscription Routines |
9.0.1 |
|
dbms_cdc_utility |
Change Data
Capture Utilities |
9.0.1 |
|
dbms_ddl |
DDL functions |
(7.3.4) |
|
dbms_debug |
Server Side
Debugger |
(7.3.4) |
|
dbms_defer |
User interface
to RPC facility |
(7.3.4) |
|
dbms_defer_query |
Query deferred
transactions queue |
(7.3.4) |
|
dbms_defer_sys |
Manage default
replication node lists |
(7.3.4) |
|
dbms_describe |
Describes
stored procedure arguments |
(7.3.4) |
|
dbms_distributed_trust_admin |
Maintains
Trusted Database List |
8.0 |
|
dbms_drs |
Hot Standby
|
9.0.1 |
|
dbms_fga |
Fine Grained
Auditing |
9.0.1 |
|
dbms_flashback |
Flashback Query
|
9.0.1 |
|
dbms_job |
Job Scheduler
|
(7.3.4) |
|
dbms_lob |
LOB Management
|
8.0 |
|
dbms_lock |
Interface to
Lock Management Services |
(7.3.4) |
|
dbms_logmnr |
Log Miner
|
8.1.5 |
|
dbms_logmnr_d |
Log Miner
Dictionary Routines |
8.1.5 |
|
dbms_logstdby |
Logical Standby
routines |
9.0.1 |
|
dbms_metadata |
Metadata
routines |
9.0.1 |
|
dbms_mview |
Materialized
Views |
8.1.5 |
|
dbms_obfuscation_toolkit |
Code
Obfuscation |
8.1.6 |
|
dbms_odci |
Extensible
Optimizer |
9.0.1 |
|
dbms_offline_og |
Offline
instantiation of master groups |
(7.3.4) |
|
dbms_offline_snapshot |
Offline
instantiation of snapshots |
8.0 |
|
dbms_outln |
Stored Outline
Administration
see OUTLN_PKG |
8.1.5 |
|
dbms_outln_edit |
Stored Outline
Editing
see
OUTLN_EDIT_PKG |
9.0.1 |
|
dbms_output |
PL/SQL Output
Buffer |
(7.3.4) |
|
dbms_pipe |
Inter-session
message pipe |
(7.3.4) |
|
dbms_profiler |
PL/SQL
Performance Profiler |
8.1.5 |
|
dbms_propagation_adm |
Streams
Propagation Process Administration |
9.2 |
|
dbms_random |
Random number
generator |
8.0 |
|
dbms_rectifier_diff |
Shows
differences between two replicated sites
see
DBMS_REPCAT_SNA |
8.0 |
|
dbms_redefinition |
Table Online
Reorgs |
9.0.1 |
|
dbms_refresh |
Refreshes
materialized views (snapshots) |
(7.3.4) |
|
dbms_repair |
Block
Corruption |
8.1.5 |
|
dbms_repcat |
Replication
Catalog and Environment Administration |
(7.3.4) |
|
dbms_repcat_admin |
Replication
User Administration |
9.0.1 |
|
dbms_repcat_instantiate |
Replication
Instantiate Deployment Templates |
8.1.5 |
|
dbms_repcat_rgt |
Replication
Refresh Group Templates |
8.1.5 |
|
dbms_repcat_sna |
Shows
differences between two replicated sites
see
DBMS_RECTIFIER_DIFF |
8.0 |
|
dbms_reputil |
Replication
utilities |
(7.3.4) |
|
dbms_resource_manager |
Plans, Consumer
groups, plan directives |
8.1.5 |
|
dbms_resource_manager_privs |
Consumer group
privileges |
8.1.5 |
|
dbms_resumable |
Resumable
session management |
9.0.1 |
|
dbms_rls |
Row Level
Security |
8.1.5 |
|
dbms_rowid |
ROWID
manipulation |
8.0 |
|
dbms_rule |
Rule evaluation |
8.1.5 |
|
dbms_rule_adm |
Rule
administration |
8.1.5 |
|
dbms_session |
Session
Utilities including ALTER Session |
(7.3.4) |
|
dbms_snapshot |
Snapshots (see
DBMS_MVIEW) |
(7.3.4) |
|
dbms_space |
Segment space
info |
(7.3.4) |
|
dbms_space_admin |
Segment space
administration |
8.1.5 |
|
dbms_sql |
Dynamic SQL |
(7.3.4) |
|
dbms_stats |
Optimizer
Statistics |
8.1.5 |
|
dbms_storage_map |
FMON Mapping
operations |
9.2 |
|
dbms_streams |
Streams
Utilities |
9.2 |
|
dbms_streams_adm |
Streams
Administration |
9.2 |
|
dbms_summary |
Summary Advisor |
8.1.5 |
|
dbms_system |
System
utilities |
(7.3.4) |
|
dbms_support |
Support
(Tracing) Routines |
8.0.6 |
|
dbms_trace |
PL/SQL Tracing |
8.1.5 |
|
dbms_transaction |
Transaction
control statements |
(7.3.4) |
|
dbms_transform |
Advanced
Queueing message format transformations |
9.0.1 |
|
dbms_tts |
Transportable
Tablespaces |
8.1.5 |
|
dbms_utility |
Miscellaneous
utility routines |
(7.3.4) |
|
dbms_wm |
Workspace
Manager |
9.2 |
|
dbms_xdb |
XML Database
Resource Management |
9.2 |
|
dbms_xdbt |
XDB
ContextIndex routines |
9.2 |
|
dbms_xdb_version |
XDB Versioning
routines |
9.2 |
|
dbms_xmldom |
XML DOM Parser |
9.2 |
|
dbms_xmlgen |
XML generation |
9.0.1 |
|
dbms_xmlparser |
Access contents
and structure of XML documents |
9.2 |
|
dbms_xmlquery |
Database to XML
routines (use DBMS_XMLGEN instead) |
8.1.7 |
|
dbms_xmlsave |
Save XML to
Database routines |
8.1.7 |
|
dbms_xmlschema |
XML Schema
Manipulation |
9.2 |
|
dbms_xplan |
Explain Plan |
9.2 |
|
dbms_xslprocessor |
XSL Processor
routines (Stylesheets) |
9.2 |
|
htf |
Web Agent
Hypertext Functions |
8.1.7 |
|
htp |
Web Agent
Hypertext Print Routines |
8.1.7 |
|
outln_edit_pkg |
Stored Outline
Editing Routines
see
DBMS_OUTLN_EDIT |
9.0.1 |
|
outln_pkg |
Stored Outlines
see DBMS_OUTLN |
8.1.5 |
|
owa |
Oracle Web
Agent Interface Procedures |
8.1.7 |
|
owa_cache |
Web Agent
Content Caching Functions |
8.1.7 |
|
owa_cookie |
Web Agent
Cookie Manipulation Functions |
8.1.7 |
|
owa_custom |
Web Agent
Customization Functions |
8.1.7 |
|
owa_image |
Web Agent Image
Handling Functions |
8.1.7 |
|
owa_opt_lock |
Web Agent
Optimistic Locking Functions |
8.1.7 |
|
owa_pattern |
Web Agent
String Manipulation Functions |
8.1.7 |
|
owa_sec |
WebServer
Security Functions |
8.1.7 |
|
owa_text |
WebServer Text
Handling Functions |
8.1.7 |
|
owa_util |
WebServer
Utility Functions |
8.1.7 |
|
standard |
Built-in
functions |
(7.3.4) |
|
urifactory |
URI
Manipulation Functions |
9.0.1 |
|
utl_coll |
Collection
Locators |
8.1.5 |
|
utl_encode |
Encodes raw
data |
9.0.1 |
|
utl_file |
External File
Access |
(7.3.4) |
|
utl_gdk |
Globalization
Development Kit |
9.2 |
|
utl_http |
HTTP access
from PL/SQL |
(7.3.4) |
|
utl_inaddr |
Internet
address API |
8.1.7 |
|
utl_raw |
SQL functions
for RAW datatypes |
(7.3.4) |
|
utl_ref |
Access to
objects via references |
8.0 |
|
utl_smtp |
SMTP E-Mail
Interface Library |
8.1.7 |
|
utl_tcp |
TCP/IP
Interface Library |
8.1.7 |
|
utl_url |
Escape
mechanism for URL characters |
9.0.1 |
|
utl_xml |
XML/XSL Utility
Library |
9.0.1 |
