The following table describes the XML functions supported by the current OceanBase Database version.
| Function | Description |
|---|---|
| XMLAGG | Obtains a set of XML fragments and returns an aggregated XML document. |
| XMLATTRIBUTES | Specifies a collection of attributes in an XML element. |
| XMLELEMENT | Generates an XML element with the specified name, attributes, and content. |
| XMLPARSE | Parses the input string and generates XMLType data. |
| EXTRACT | Extracts an XML fragment based on an XPath. All nodes matching the XPath are concatenated to generate this XML fragment. |
| EXTRACTVALUE | Extracts an XML fragment based on an XPath and returns the scalar value of the XML fragment. |
| XMLSERIALIZE | Serializes XMLType data into data of a string type such as VARCHAR2 or CLOB. |
| XMLCAST | Extracts the content (excluding element names) of an XML document and casts the content to data of another type. |
| XMLTABLE | Maps the result returned based on an XPath to rows and columns in a relational table. |
| XMLSEQUENCE | Converts the content of an XML document into a varray of XML elements. |
| UPDATEXML | Updates an expression of XMLType data. |
| INSERTCHILDXML | Inserts the specified XML fragment into the target XML document. |
| DELETEXML | Deletes one or more nodes that match an XPath expression from the target XML document. |
The following table describes the XML functions that are not supported by the current OceanBase Database version.
| Function | Description |
|---|---|
XMLEXIST |
Verifies whether a specified XPath exists in XML data. |
XMLISVALID |
Verifies whether an XML document conforms to the definition of the XML schema. |
XMLQUERY |
Executes an XQuery expression to query XML data. |