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

Advanced SQL Engine
Teradata Database
Release Number
July 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)
Last Update
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.