Oracle Supplied Packages
The following is a selected list of available Oracle packages and a description of their purpose.
This list does not include packages specifically related to database administration,
security, moving data between databases, scheduling jobs within the database,
queuing and other specialized optional packages.
Identifying Available Packages
Oracle supplied packages can be associated with various owner/schemas. The packages
available vary by the database version, edition type (Standard, Enterprise) and options installed.
To see the available Oracle installed packages owned by SYS in your installation, run the following query when logged in with a username (such as SYSTEM) that has permission to select the DBA_OBJECTS view.
SELECT DISTINCT owner, object_name
WHERE owner = 'SYS'
AND object_Type = 'PACKAGE'
ORDER BY owner, object_name;
Identifying Package Subprograms
Oracle supplied package specifications can be referenced the same way as
user defined packages. From the SQL*Plus command line, use the describe
command and from SQL Developer click on the Connection Navigator tree on the left
hand side of the screen.
Selected Oracle Supplied Package Demos
The following are a few examples of Oracle supplied packages that are commonly available and do not
require special configuration or administrative prerequisites. The first of these will be of interest
to PL/SQL developers interested in taking advantage of new language features but work in environments
with a mixture of Oracle versions.