Example: Using XMLELEMENT to Construct an XML Element Node - Advanced SQL Engine - Teradata Database

This query returns an XML element that has a serialization of <Item ID="001"/>:

SELECT XMLELEMENT(NAME Item, XMLATTRIBUTES('001' AS ID));

The result of the query is:

XMLELEMENT(NAME Item, XMLATTRIBUTES('001' AS ID) RETURNING SEQUENCE)
--------------------------------------------------------------------
<Item ID="001"></Item>

This query returns an XML element that has a serialization of <Item xmlns="http://example.teradata.com" ID="001"/>:

SELECT XMLELEMENT(NAME Item, XMLNAMESPACES(DEFAULT 'http://example.teradata.com'),
   XMLATTRIBUTES('001' AS ID));

The result of the query is:

XMLELEMENT(NAME Item, XMLNAMESPACES(DEFAULT 'http://example.teradata.com'),
XMLATTRIBUTES('001' AS ID) RETURNING SEQUENCE)
---------------------------------------------------------------------------
<Item ID="001" xmlns="http://example.teradata.com"></Item>