16.20 - Example: Using XMLEXTRACT to Evaluate a Query Against an XML Instance - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

In this example, the XPath expression (in bold) is extracting the Address elements in the XML documents for the customer named John Hancock.

SELECT customerXML.XMLEXTRACT('/Customer[Name="John Hancock"]/Address', '')
FROM customer
WHERE customerID = 1;

Query result:

customerXML.XMLEXTRACT('/Customer[Name="John Hancock"]/Address', '')
<Address>100 1st Street, San Francisco, CA 94118</Address>