Methods on the XML type support common XML operations like parsing, validation, transformation (XSLT) and query (XPath and XQuery).
Wherever string representations of XML values are required, you can use VARCHAR and CLOB typed values for small documents (<64K) and large documents (< 2GB).
| IF you want to... | THEN use this method... |
|---|---|
| add type annotations to an XML value | CREATESCHEMABASEDXML |
| remove type annotations from XML values | CREATENONSCHEMABASEDXML |
| execute an XSLT transform on the XML value using a specified stylesheet | XSLTTRANSFORM |
| execute an XPath or XQuery query against the XML value | XMLEXTRACT |
| check if a query will return a node | EXISTSNODE |
| check if the XML value is a well-formed XML document | ISDOCUMENT |
| check if the XML value is a document node with one or more child elements | ISCONTENT |
| check if the XML value has been validated and has type annotations | ISSCHEMAVALIDATED |
| check if the XML value is valid according to a specified schema | ISSCHEMAVALID |