XMLType
Last updated
Last updated
This Oracle-supplied type can be used to store and query XML data in the database.
XMLType
has member functions you can use to access, extract, and query the XML data using XPath expressions. ()
Snowflake handles semi-structured data types (including XMLTYPE) using the VARIANT data type, for this reason, XMLTYPEs are to be migrated to VARIANT, and then usages of functions used to manipulate and query XML must be migrated to Snowflake's counterparts. For more information on how to use XML in Snowflake, please refer to in the Snowflake forum and the function documentation in Snowflake.
The functions for manipulating and querying XML such as XMLTYPE() are not being recognized nor transformed by SnowConvert.
XMLTYPE DATA TYPE CONVERTED TO VARIANT