|
Oracle DATE datatype is used to store point-in-time values related to date and time. Oracle date datatype is stored in fixed length field of 7 bytes allows the storing of the year in 4 digit format, month, day, hours, minutes and seconds. Oracle dates are stored in julian era starting from January 1, 4712 BC through December 31, 4172 AD. Dates are defaulted to AD unless the format mask BC is specifically used |
UTL_TCP allows communication with external TCP Services.
|
UTL_SMTP is designed for sending e-mail over Simple Mail Transfer Protocol (SMTP).
|
The UTL_RAW package provides SQL functions for manipulating RAW datatypes.
|
UTL_HTTP allows you to write PL/SQL programs that communicate with Web (HTTP) servers.
|
UTL_FILE package built into the oracle database allows PL/SQL programs to read and write to an operating system file.
|
|
DBMS_UTILITY Package offers the API to support various utility functions of the PL/SQL System.
|
|
DBMS_STATS Provides an API into the Optimizer statistics of the Oracle Optimizer
|
|
The DBMS_SQL package provides an interface to use dynamic SQL to parse
any data manipulation language (DML) or data definition language (DDL)
statement using PL/SQL.
|
|
DBMS_SHARED_POOL provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects are stored.
|
DBMS_SESSION package provides access to SQL ALTER SESSION and SET ROLE statements, and other session information, from PL/SQL.
|
DBMS_REDEFINITION package is used to redefine table columns and column names. The dbms_redefinition package allows you to copy a table, create a snapshot on the table, enqueue changes during the redefinition, and then re-synchronize the restructured table with the changes that have accumulated during reorganization.
|
|
DBMS_PIPE package lets two or more sessions communicate in the same
instance. Oracle pipes are similar in concept to the pipes used in
UNIX, but Oracle pipes are not implemented using the operating system
pipe mechanisms.
|
|
DBMS_OUTPUT oracle package enables you to send output messages from
various other PL/SQL program units like stored procedures, packages,
triggers etc.DBMS_OUTPUT is primarily used for displaying messages or
debug information from a PL/SQL Program. The procedures contained in
this package are DISABLE, ENABLE, PUT, PUT_LINE, GET_LINE, GET_LINES
and NEW_LINE.
|
|
The DBMS_OUTLN package, synonymous with OUTLN_PKG, contains the
functional interface for subprograms associated with the management of
stored outlines. A stored outline is the stored data that pertains to
an execution plan for a given SQL statement.
|
|
The DBMS_OLAP package provides a collection of materialized view
analysis and advisory functions that are callable from any PL/SQL
program.
|
|
DBMS_MVIEW package enables you to understand capabilities for
materialized views and potential materialized views, including their
rewrite availability.
|
|
The DBMS_LOCK package provides an interface to Oracle Lock Management services. DBMS_LOCK is most efficient with a limit of a few hundred locks per session.
|
|
The Oracle DBMS_LOB package provides subprograms to operate on BLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBs.
|
Oracle DBMS_JOB package is a built-in package that is used as an API/Interface to manage the Oracle job queue. The oracle job queue is the mechanism that is used to schedule the execution of various PL/SQL Blocks or Procedures at predefined intervals of time.
|
|
|
