Oracle in a Nutshell

Calls

FUNCTION DBMS_XMLQUERY.newContext (sqlQuery IN VARCHAR2 | CLOB) RETURN ctxType;

Creates a query context from sqlQuery and returns handle.

PROCEDURE DBMS_XMLQUERY.closeContext (ctxHandle IN ctxType);

Closes ctxHandle.

PROCEDURE DBMS_XMLQUERY.setRowsetTag (ctxHandle IN ctxType, tag IN VARCHAR2);

Sets tag used to enclose data set for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setRowTag (ctxHandle IN ctxType, tag IN VARCHAR2);

Sets tag used to enclose database record for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setErrorTag (ctxHandle IN ctxType, tag IN VARCHAR2);

Sets tag used to enclose error documents for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setRowIdAttrName (ctxHandle IN ctxType, attrName IN VARCHAR2);

Sets attrName for the id attribute of the row-enclosing tag for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setRowAttrValue (ctxHandle IN ctxType, colName IN VARCHAR2);

Sets colName for the column whose value will be used for the id attribute of the row-enclosing tag for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setCollIdAttrName (ctxHandle IN ctxType, attrName IN VARCHAR2);

Sets attrName for the id attribute of the element-separating tag for ctxHandle.

PROCEDURE DBMS_XMLQUERY.useNullAttributeIndicator (ctxHandle IN ctxType, tag IN BOOLEAN);

Sets whether or not to use XML attribute for NULLs.

PROCEDURE DBMS_XMLQUERY.useTypeForCollElemTag (ctxHandle IN ctxType, tag IN BOOLEAN :=);

Sets whether to use the collection element’s type name as the collection element tag name for ctxHandle.

PROCEDURE DBMS_XMLQUERY.setTagCase ...