Oracle pl/sql note

DBMS_METADATA
BEGIN DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'PRETTY', true); END;
DBMS_METADATA.GET_DDL

Oracle 11g new features:
continue support
virtual column
disabled triggers
result cache

The advantage to using RAISE_APPLICATION_ERROR instead of RAISE is that you can associate
an error message with the exception.

SQLERRM will return is 512 bytes, Oracle recommends DBMS_UTILITY.FORMAT_ERROR_STACK
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE --see the error line number

System exception
An exception that is defined by Oracle and is usually raised by the PL/SQL runtime
engine when it detects an error condition. Some system exceptions have names,
such as NO_DATA_FOUND, while many others simply have numbers and
descriptions.
Programmer-defined exception
An exception that is defined by the programmer and is therefore specific to the
application at hand. You can associate exception names with specific Oracle errors
using the EXCEPTION_INIT pragma (a compiler directive, requesting a specific
behavior), or you can assign a number and description to that error using
RAISE_APPLICATION_ERROR.

Associative arrays:
 like hash table
Nested tables:
 unbounded
 become sparse through deletions
 no inherent order to the elements
varrays:
 must specify the max number of elements
 never sparse
 element order is preserved