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 and casts the content to data of another type. |
| UPDATEXML | Updates an expression of XMLType data. |
The XML functions currently not supported by OceanBase Database are as follows:
| Function | Description |
|---|---|
XMLTABLE |
Converts an XML document into a relational table. |
XMLEXIST |
Checks if the specified XPath path exists in the XML data. |
XMLISVALID |
Validates if an XML document conforms to its XML Schema definition. |
XMLQUERY |
Executes XQuery expressions to query XML data. |