Example: Using XMLTEXT to Create an XML Text Node - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

The following query returns a sequence with the text node with the node value 'Special instructions for processing this order' as its only item.

SELECT XMLTEXT('Special instructions for processing this order');

Query result:

XMLTEXT('Special instructions for processing this order' RETURNING SEQUENCE)
----------------------------------------------------------------------------
Special instructions for processing this order