Some of the Builtin Packages Stored in the Oracle Database

 Some of the Builtin Packages Stored in the Oracle Database

Package Name	Description
DBMS_ALERT	Provides support for notification of database events on an asynchronous basis. Registers a process with an alert and then waits for a signal from that alert.
DBMS_DDL	Provides a programmatic access to some of the SQL DDL statements.
DBMS_JOB	Used to submit and manage regularly scheduled jobs for execution inside the database.
DBMS_LOCK	Allows users to create their own locks using the Oracle Lock Management (OLM) services in the database.
DBMS_MAIL	Offers an interface to Oracle Office (previously known as Oracle Mail).
DBMS_OUTPUT	Displays output from PL/SQL programs to the terminal. The "lowest common denominator" debugger mechanism for PL/SQL code.
DBMS_PIPE	Allows communication between different Oracle sessions through a pipe in the RDBMs shared memory. One of the few ways to share memory-resident data between Oracle sessions.
DBMS_SESSION	Provides a programmatic interface to several SQL ALTER SESSION commands and other session-level commands.
DBMS_SNAPSHOT	A programmatic interface through which you can manage snapshots and purge snapshot logs. You might use modules in this package to build scripts to automate maintenance of snapshots.
DBMS_SQL	Full support for dynamic SQL within PL/SQL. Dynamic SQL means SQL statements that are not prewritten into your programs. They are, instead, constructed at runtime as character strings and then passed to the SQL Engine for execution. (PL/SQL Release 2.1 only)
DBMS_TRANSACTION	A programmatic interface to a number of the SQL transaction statements, such as the SET TRANSACTION command.
DBMS_UTILITY	The "miscellaneous" package. Contains various useful utilities, such as GET_TIME, which calculates elapsed time to the hundredth of a second, and FORMAT_CALL_STACK, which returns the current execution stack in the PL/SQL runtime engine.
UTL_FILE	Allows PL/SQL programs to read from and write to operating system files. (PL/SQL Release 2.3 only)