XMLELEMENT
The XMLELEMENT function creates an XML node with an optional XML attributes node.
Syntax
XMLELEMENT ( NAME <XML_element_name>
[ , <XML_namespace_declaration> ] [ , <XML_attributes> ]
[ { , <XML_element_content> }...
[ OPTION <XML_content_option> ] ]
[ <XML_returning_clause> ] )
Remarks
• The first argument, XML_element_name, is the name of the XML node. It can be escaped if it contains certain characters. For details, see
Identifier Escaping.
• The optional second argument, XML_namespace_declaration, is the XMLNAMESPACE function.
• The optional third argument, XML_attributes, is the XMLATTRIBUTES function.
• The optional fourth argument, XML_element_content, is the content of the XML node, which can be an XML, numeric, or character type.
• If XML_element_content evaluates to a character literal, it is escaped. For details, see
Text Escaping.
Example
SELECT XMLELEMENT (name Details, XMLATTRIBUTES (ProductID AS product),
XMLELEMENT (name orderno, OrderID),
XMLELEMENT (name status, Status),
XMLELEMENT (name price, UnitPrice)) myOutput
FROM /shared/examples/ds_orders/orderdetails
WHERE ProductID < 20