XMLPARSE() and TO_XML() functions

Scalar. Converts (casts) a string expression to XML.

Syntax

XMLPARSE( value ) TO_XML( value )

Parameters
value	The value to convert.

Data Types
Return	value
XML	String
XML	XML

The following example shows an extraction, serialization (to string), and reparsing:

INSERT INTO OutStream
SELECT XMLPARSE(XMLSERIALIZE(XMLEXTRACT(OrderVal2,'//item')))
FROM Orders;