Teradata Support for XML | XML Data Type | Teradata Vantage - 17.10 - Teradata Support for XML - 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
Vantage provides the following support for storing and processing XML data:
  • An XML data type that allows you to store XML content in a compact binary form that preserves the information set of the XML document
  • Functions and methods on the XML type that support common XML operations like parsing, validation, transformation (XSLT) and Query (XPath and XQuery)
  • The XQuery query language for querying and transforming XML content
  • Stored procedures that allow you to publish the results of SQL queries in XML format
  • Shredding functionality that allows you to extract values from XML documents and use them to update database tables