XMLType is a system-defined type for processing XML data.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
The following table describes the XMLType subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| CREATEXML | A static function used to create and return an XMLType instance. |
| GETCLOBVAL | Returns the value of the XMLType instance as a CLOB. |
| GETSTRINGVAL | Returns the value of the XMLType instance as a string. |
| TRANSFORM | Obtains an XMLType instance and an associated stylesheet (also an XMLType instance), applies the stylesheet, and returns the result as XML data. |
| XMLTYPE | Constructs an XMLType instance. The constructor can take XML as the CLOB, VARCHAR2, or corresponding object type. |