ORACLE SUPPLIED PACKAGES

DBMS_SQL Package In Oracle:

DEFINITION:

• DBMS_SQL package provides an interface to use dynamic sql statement to execute various types of statements. Like DML, DDL statement, anonymous plsql block, stored procedure or function using PLSQL.
• Native dynamic sql statement (EXECUTE IMMEDIATE)

…

UTL_FILE PACKAGE In Oracle:

UTL_FILE:

With this package, a plsql subprogram or block can read from or write to a operating system file.

SETUP:

UTL_FILE uses the oracle directories and not the OS directories. So a logical directory to be …

DBMS_OUTPUT Package In Oracle

INTRODUCTION:

• DBMS_OUTPUT package helps us to send messages from stored procedures, functions, packages, triggers or any plsql block.
• This package is mainly used for debugging purposes.

PROCEDURES AVAILABLE IN DBMS_OUTPUT PACKAGE:

• DISABLE
• ENABLE
• GET_LINE
• GET_LINES
• NEW_LINE

…

DBMS_UTILITY Package In Oracle

INTRODUCTION:

DBMS_UTILITY is a oracle supplied package which is a collection of many stand alone procedures which are used for various purposes.

STRUCTURE:

DBMS_UTILITY package defines a single record type and few table types.

RECORD TYPE:

…

DBMS_LOCK PACKAGE In Oracle

INTRODUCTION:

This package is used for managing lock operation in PLSQL:

• LOCK
• CONVERSION
• RELEASE

SUBPROGRAMS OF DBMS_LOCK PACKAGE:

• ALLOCATE_UNIQUE PROCEDURE
• REQUEST FUNCTION
• CONVERT FUNCTION
• RELEASE FUNCTION
• SLEEP PROCEDURE

ALLOCATE_UNIQUE PROCEDURE:

• The ALLOCATE_UNIQUE procedure returns a unique

…