Convert XML Data to Relational Data | XML Data Type | Teradata Vantage - 17.10 - Converting XML Data to Relational Data - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
You can use the XMLTABLE function to convert an XML tree structure into zero or more rows:
  1. Compose an XQuery query that will generate a sequence. Each item of this sequence will generate a corresponding row.
  2. Determine the row format (column name, type of all the columns) and determine the path expression that will return the value of the column. The path expression should be relative to the items returned by the query in step (1).
  3. Compose a query which calls the XMLTABLE function to turn the XML documents into rows.