Oracle in a Nutshell

Calls

PROCEDURE DBMS_METADATA.OPEN (object_type IN VARCHAR2, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE') RETURN NUMBER;

Specifies object_type, version, and object model and returns a context handle used in subsequent calls.

PROCEDURE DBMS_METADATA.SET_FILTER (handle IN NUMBER, name IN VARCHAR2, value IN {VARCHAR2 | BOOLEAN DEFAULT TRUE});

Specifies restrictions on objects to be retrieved. The name parameter refers to the name of a filter, as explained in the Oracle documentation.

PROCEDURE DBMS_METADATA.SET_COUNT (handle IN NUMBER, value IN NUMBER);

Specifies the maximum number of objects (value) to be retrieved with a FETCH_* procedure.

PROCEDURE DBMS_METADATA.GET_QUERY (handle IN NUMBER) RETURN VARCHAR2;

Returns the text of queries used by the FETCH_* procedure.

PROCEDURE DBMS_METADATA.SET_PARSE_ITEM (handle IN NUMBER, name IN VARCHAR2);

Specifies an output attribute (name) to be parsed and returned with the FETCH_DDL procedure.

PROCEDURE DBMS_METADATA.ADD_TRANSFORMATION (handle IN NUMBER, name IN VARCHAR2, encoding IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;

Requests that a transformation be applied to the XML representation of objects retrieved. Returns a handle to the transformed representation.

PROCEDURE DBMS_METADATA.SET_TRANSFORM_PARAM (transform_handle IN NUMBER, name IN VARCHAR2, value IN {VARCHAR2 | BOOLEAN DEFAULT TRUE});

Specifies parameters to the XSLT stylesheet identified by transform_handle used to modify output of the transformation. ...