Oracle PL SQL

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 the DBMS_OUTPUT package include DISABLE, ENABLE, PUT, PUT_LINE, GET_LINE, GET_LINES and NEW_LINE.

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.