XMLSERIALIZE()

Scalar. Converts an XML value to a String. Note that this function is the same as TO_STRING() with an XML parameter.

Syntax

XMLSERIALIZE( value )

Parameters
value	The value to convert.

Data Types
Return	value
String	XML
String	String

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

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