XMLDOCUMENT
The XMLDOCUMENT function generates an XML value with a single XQuery document node. It is equivalent to running the XQUERY expression.
Syntax
XMLDOCUMENT ( <XML_value_expression> [ <XML_returning_clause> ] )
The <XML_value_expression> is a sequence of nodes of atomic values.
Example
SELECT XMLDOCUMENT (XMLELEMENT (name Details, XMLATTRIBUTES (ProductID as product),
XMLELEMENT (name orderno, OrderID),
XMLELEMENT (name status, Status),
XMLELEMENT (name price, UnitPrice))) myXMLDocument
FROM /shared/examples/ds_orders/orderdetails
WHERE ProductID < 20