December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...