XMLType is an SQL data type for storing XML data. It is an abstract data type that provides XMLType constructors and various PL/SQL methods for XML operations. XMLType can be used in the same way as other SQL data types. For example, you can create an XMLType table or view. In PL/SQL stored procedures, XMLType can be used as a parameter, return value, or variable.
XPath expressions can be used to query and update XML documents. Additionally, OceanBase Database supports various XMLType functions that can efficiently query, update, and search XML documents. For more information about XML functions, see XML functions.
