List of Oracle Database XE Packages

DBMS_ALERT

Provides support for the asynchronous notification of database events.

DBMS_APPLICATION_INFO

Lets you register an application name with the database for auditing or performance tracking purposes.

DBMS_CHANGE_NOTIFICATION

Is part of a set of features that clients use to receive notifications when result sets of a query have changed. The package contains interfaces that can be used by mid-tier clients to register objects and specify delivery mechanisms.

DBMS_CRYPTO

Lets you encrypt and decrypt stored data, can be used in conjunction with PL/SQL programs running network communications, and supports encryption and hashing algorithms.

DBMS_DATAPUMP

Lets you move all, or part of, a database between databases, including both data and metadata.

DBMS_DB_VERSION

Specifies the Oracle version numbers and other information useful for simple conditional compilation selections based on Oracle versions.

DBMS_DDL

Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs.

DBMS_DEBUG

Implements server-side debuggers and provides a way to debug server-side PL/SQL program units.

DBMS_DESCRIBE

Describes the arguments of a stored procedure with full name translation and security checking.

DBMS_EPG

Implements the embedded PL/SQL gateway that enables a Web browser to invoke a PL/SQL stored procedure through an HTTP listener.

DBMS_ERRLOG

Provides a procedure that enables you to create an error logging table so that DML operations can continue after encountering errors rather than abort and roll back.

DMBS_FILE_TRANSFER

Lets you copy a binary file within a database or to transfer a binary file between databases.

DBMS_JOB

Lets you schedule administrative procedures that you want performed at periodic intervals; it is also the interface for the job queue.

DBMS_LOCK

Lets you request, convert and release locks through Oracle Lock Management services.

DBMS_METADATA

Lets callers easily retrieve complete database object definitions (metadata) from the dictionary.

DBMS_OBFUSCATION_TOOLKIT

Provides procedures for Data Encryption Standards.

DBMS_OUTPUT

Displays output from stored procedures, packages, and triggers, which is especially useful for displaying PL/SQL debugging information.

DBMS_PIPE

Provides a DBMS pipe service which enables messages to be sent between sessions.

DBMS_RANDOM

Provides a built-in random number generator.

DBMS_RESUMABLE

Lets you suspend large operations that run out of space or reach space limits after executing for a long time, fix the problem, and make the statement resume execution.

DBMS_ROWID

Provides procedures to create rowids and to interpret their contents.

DBMS_SCHEDULER

Provides a collection of scheduling functions that are callable from any PL/SQL program.

DBMS_SERVER_ALERT

Lets you issue alerts when some threshold has been violated.

DBMS_SESSION

Provides access to SQL ALTER SESSION statements, and other session information, from stored procedures.

DBMS_SQL

Lets you use dynamic SQL to access the database.

DBMS_TDB

Reports whether a database can be transported between platforms using the RMAN CONVERT DATABASE command. It verifies that databases on the current host platform are of the same endian format as the destination platform, and that the state of the current database does not prevent transport of the database.

DBMS_TTS

Checks if the transportable set is self-contained.

DBMS_TYPES

Consists of constants, which represent the built-in and user-defined types.

DBMS_UTILITY

Provides various utility routines.

DBMS_WARNING

Provides the interface to query, modify and delete current system or session settings.

DBMS_XDB

Describes Resource Management and Access Control APIs for PL/SQL

DBMS_XDB_VERSION

Describes versioning APIs

DBMS_XDBT

Describes how an administrator can create a ConText index on the XML DB hierarchy and configure it for automatic maintenance

DBMS_XDBZ

Controls the Oracle XML DB repository security, which is based on Access Control Lists (ACLs).

DBMS_XMLDOM

Explains access to XMLType objects

DBMS_XMLGEN

Converts the results of a SQL query to a canonical XML format.

DBMS_XMLPARSER

Explains access to the contents and structure of XML documents.

DMBS_XMLQUERY

Provides database-to-XMLType functionality.

DBMS_XMLSAVE

Provides XML-to-database-type functionality.

DBMS_XMLSCHEMA

Explains procedures to register and delete XML schemas.

DBMS_XMLSTORE

Provides the ability to store XML data in relational tables.

DBMS_XPLAN

Describes how to format the output of the EXPLAIN PLAN command.

DBMS_XSLPROCESSOR

Explains access to the contents and structure of XML documents.

HTF

Hypertext functions generate HTML tags.

HTMLDB_APPLICATION

Enables users to take advantage of global variables

HTMLDB_CUSTOM_AUTH

Enables users to create form elements dynamically based on a SQL query instead of creating individual items page by page.

HTMLDB_ITEM

Enables users to create form elements dynamically based on a SQL query instead of creating individual items page by page.

HTMLDB_UTIL

Provides utilities for getting and setting session state, getting files, checking authorizations for users, resetting different states for users, and also getting and setting preferences for users.

HTP

Hypertext procedures generate HTML tags.

OWA_CACHE

Provides an interface that enables the PL/SQL Gateway cache to improve the performance of PL/SQL Web applications.

OWA_COOKIE

Provides an interface for sending and retrieving HTTP cookies from the client's browser.

OWA_CUSTOM

Provides a Global PLSQL Agent Authorization callback function

OWA_IMAGE

Provides an interface to access the coordinates where a user clicked on an image.

OWA_OPT_LOCK

Contains subprograms that impose optimistic locking strategies so as to prevent lost updates.

OWA_PATTERN

Provides an interface to locate text patterns within strings and replace the matched string with another string.

OWA_SEC

Provides an interface for custom authentication.

OWA_TEXT

Contains subprograms used by OWA_PATTERN for manipulating strings. They are externalized so you can use them directly.

OWA_UTIL

Contains utility subprograms for performing operations such as getting the value of CGI environment variables, printing the data that is returned to the client, and printing the results of a query in an HTML table.

UTL_COLL

Enables PL/SQL programs to use collection locators to query and update.

UTL_COMPRESS

Provides a set of data compression utilities.

UTL_DBWS

Provides database Web services.

UTL_ENCODE

Provides functions that encode RAW data into a standard encoded format so that the data can be transported between hosts.

UTL_FILE

Enables your PL/SQL programs to read and write operating system text files and provides a restricted version of standard operating system stream file I/O.

UTL_HTTP

Enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to call Oracle Web Server Cartridges.

UTL_I18N

Provides a set of services (Oracle Globalization Service) that help developers build multilingual applications.

UTL_INADDR

Provides a procedure to support internet addressing.

UTL_LMS

Retrieves and formats error messages in different languages.

UTL_MAIL

A utility for managing e-mail which includes commonly used e-mail features, such as attachments, CC, BCC, and return receipt.

UTL_RAW

Provides SQL functions for RAW datatypes that concat, substr to and from RAWS.

UTL_RECOMP

Recompiles invalid PL/SQL modules, Java classes, indextypes and operators in a database, either sequentially or in parallel.

UTL_REF

Enables a PL/SQL program to access an object by providing a reference to the object.

UTL_SMTP

Provides PL/SQL functionality to send e-mails.

UTL_TCP

Provides PL/SQL functionality to support simple TCP/IP-based communications between servers and the outside world.

UTL_URL

Provides escape and unescape mechanisms for URL characters.