|
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.
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
|
| Results 11 - 15 of 69 |