Oracle XMLTYPE Data Type Version 21c |
---|
General Information | ||
Library Note |
|
|
Purpose | A data type that understands native XML and contains methods for validating, transforming, and modifying XML documents. | |
AUTHID | CURRENT_USER | |
Dependencies | SELECT name FROM dba_dependencies WHERE referenced_name = 'XMLTYPE' |
|
Documented | No | |
First Available | 9.0.1.1.0 | |
Security Model | Owned by SYS with EXECUTE granted to PUBLIC with GRANT OPTION and to DVSYS | |
Source | {ORACLE_HOME}/rdbms/admin/dbmsxmlt.plb | |
Subprograms |
|
|
Demo Tables and Data | ||
Build Script | CREATE TABLE xmltypetab OF XMLTYPE; |
|
APPENDCHILDXML | ||
Undocumented | MEMBER FUNCTION appendChildXML( |
|
TBD | ||
CREATENONSCHEMABASEDXML | ||
Creates a non-schema based XML from the input schema based instance (self) | MEMBER FUNCTION createNonSchemaBasedXML RETURN sys.XMLType |
|
SELECT sc.cart_data.createNonSchemaBasedXML() |
||
CREATESCHEMABASEDXML | ||
Creates a schema based XMLType instance from the non-schema based instance using the input schema URL | MEMBER FUNCTION createSchemaBasedXML(schema IN VARCHAR2 := NULL) |
|
SELECT sc.cart_data.createSchemaBasedXML() |
||
CREATEXML | ||
Static function for creating and returning an XMLType instance Overload 1 |
STATIC FUNCTION createXML(xmlData IN CLOB) |
|
DECLARE |
||
Overload 2 | STATIC FUNCTION createXML(xmlData IN VARCHAR2) |
|
DECLARE |
||
Overload 3 | STATIC FUNCTION createXML ( |
|
TBD | ||
Overload 4 | STATIC FUNCTION createXML( |
|
TBD | ||
Overload 5 | STATIC FUNCTION createXML( |
|
TBD | ||
Overload 6 | STATIC FUNCTION createXML( |
|
TBD | ||
Overload 7 | STATIC FUNCTION createXML( |
|
TBD | ||
Overload 8 | STATIC FUNCTION createXML( |
|
TBD | ||
Overload 9 | STATIC FUNCTION createXML( |
|
TBD | ||
CREATEXMLFROMBINARY | ||
Undocumented | STATIC FUNCTION createXMLFromBinary(xmlData IN BLOB) |
|
TBD | ||
DELETEXML | ||
Undocumented | MEMBER FUNCTION deleteXML( |
|
TBD | ||
EXISTSNODE | ||
Takes a XMLType instance and a XPath and returns 1 or 0 indicating if applying the XPath returns a non-empty set of nodesOverload 1 |
MEMBER FUNCTION existsNode(xpath IN VARCHAR2) RETURN NUMBER |
|
SELECT COUNT(*) |
||
Overload 2 | MEMBER FUNCTION existsNode(xpath in VARCHAR2, nsmap in VARCHAR2) |
|
TBD | ||
EXTRACT | ||
Takes a XMLType instance and an XPath and applies the XPath expression Overload 1 |
MEMBER FUNCTION extract(xpath IN VARCHAR2) RETURN sys.XMLType |
|
CREATE TABLE xmldemo OF
XMLType; |
||
Overload 2 | MEMBER FUNCTION extract(xpath IN VARCHAR2, nsmap IN VARCHAR2) |
|
TBD | ||
GETBLOBVAL | ||
Extracts XMLTYPE and casts it as a BLOB Overload 1 |
MEMBER FUNCTION getBlobVal(csid IN NUMBER) RETURN BLOB |
|
TBD | ||
Overload 2 | MEMBER FUNCTION getBlobVal( |
|
TBD | ||
GETCLOBVAL | ||
Extracts XMLTYPE and casts it as a CLOB Overload 1 |
MEMBER FUNCTION getClobVal RETURN CLOB DETERMINISTIC PARALLEL_ENABLE; |
|
CREATE TABLE cart_with_clob AS |
||
Overload 2 | MEMBER FUNCTION xmltype.getCLOBVal( |
|
TBD | ||
GETNAMESPACE | ||
Returns the namespace for the top level element in a schema based document | MEMBER FUNCTION getNamespace RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE; |
|
DECLARE |
||
GETNUMBERVAL | ||
If the input XMLType instance contains a simple text node and is convertible to a number returns the value of the XMLType instance as a NUMBER. | MEMBER FUNCTION getNumberVal RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE; |
|
TBD | ||
GETROOTELEMENT | ||
Returns the root element of the input instance. Returns NULL if the instance is a fragment | MEMBER FUNCTION xmltype.getRootElement RETURN VARCHAR2 |
|
SELECT sc.cart_data.getRootElement() |
||
GETSCHEMAID | ||
Undocumented | MEMBER FUNCTION xmltype.getSchemaID RETURN RAW DETERMINISTIC PARALLEL_ENABLE; | |
TBD | ||
GETSCHEMAURL | ||
Returns the XML schema URL if the input XML Schema based | MEMBER FUNCTION xmltype.getSchemaURL RETURN VARCHAR2 |
|
TBD | ||
GETSTRINGVAL | ||
Returns the value of the XMLType instance as a string Overload 1 |
MEMBER FUNCTION xmltype.getStringVal() RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE; |
|
SELECT sc.cart_data.getStringVal() |
||
Overload 2 | MEMBER FUNCTION getStringVal(pflag IN NUMBER, indent IN NUMBER) |
|
TBD | ||
INSERTXMLBEFORE | ||
Undocumented | MEMBER FUNCTION insertXMLBefore( |
|
TBD | ||
ISFRAGMENT | ||
Checks if the input XMLType instance is a fragment or not. A fragment is a XML instance, which has more than one root element | xmltype.isFragment RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE; |
|
SELECT sc.cart_data.isFragment() |
||
ISSCHEMABASED | ||
Returns 1 or 0 indicating if the input XMLType instance is a schema based one or not | MEMBER FUNCTION isSchemaBased RETURN NUMBER |
|
SELECT sc.cart_data.isSchemaBased() |
||
ISSCHEMAVALID | ||
Checks if doc conforms to a specified schema: non mutating | MEMBER FUNCTION isSchemaValid( |
|
conn uwclass/uwclass@pdbdev |
||
ISSCHEMAVALIDATED | ||
Returns the value of the VALIDATED flag of the document; tells if a schema based doc. has been actually validated against its schema | MEMBER FUNCTION isSchemaValidated RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE; |
|
See isSchemaValid Demo Above |
||
SCHEMAVALIDATE | ||
Validates the input instance according to the XML Schema. Raises an error if the input instance is non-schema based | MEMBER PROCEDURE schemaValidate(self IN OUT NOCOPY XMLType); |
|
TBD | ||
SETSCHEMAVALIDATED | ||
Sets the schema valid flag to avoid costly schema validation | MEMBER PROCEDURE setSchemaValidated( |
|
See isSchemaValid Demo Above |
||
TOOBJECT | ||
Converts the XMLType instance to an object type | MEMBER PROCEDURE toObject( |
|
TBD | ||
TRANSFORM | ||
Takes an XMLType instance and an associated stylesheet (which is also an XMLType instance), applies the stylesheet and returns the result as XML | MEMBER FUNCTION transform( |
|
TBD | ||
XMLTYPE | ||
Constructs an instance of the XMLType datatype. The constructor can take in the XML as a CLOB, VARCHAR2 or an object type Overload 1 |
CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 2 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 3 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 4 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 5 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 6 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD | ||
Overload 7 | CONSTRUCTOR FUNCTION XMLType( |
|
TBD |
This site is maintained by Dan Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||