Functional Description - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢

XMLAGG aggregates multiple rows to construct an XML value. During aggregation, for a given collection of rows processed by the function, XML_value_expr is evaluated for every row and the resulting values are ordered according to the ORDER BY clause and concatenated according to the XML value concatenation semantics (same as XMLCONCAT), after eliminating NULLs.