The following table describes the XML functions supported by the current OceanBase Database version.
| Function name | 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. |
| EXTRACT VALUE | 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 or fragment and casts the content to data of another type. |
| UPDATEXML | Updates an expression of XMLType data. |