17.10 - XPath/XQuery Result Retrieval - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following examples return results of an XQuery/XPath query evaluation. If the result is a single document or element node, it can be returned directly. If the result is a sequence, it can be cast to a string data type (VARCHAR, CLOB), or you can use the XMLSERIALIZE function to return a string representation of the value. Alternately, you can use the XMLTABLE function to split up items of a sequence. If the items are atomic values, you can cast them to the appropriate SQL type.