XMLTEXT Syntax - Analytics Database - Teradata Vantage

XML Data Type

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantageā„¢
XMLTEXT (
  char_value_expr
  [ RETURNING { CONTENT | SEQUENCE } ]
)

Syntax Elements

char_value_expr
A string that specifies the node value.
The data type of char_value_expr is CLOB, CHAR(n), or VARCHAR(n), where n is as close to 64K as permitted. If the type is CLOB, it cannot be larger than 64K.
If char_value_expr is NULL, the function returns NULL.
RETURNING CONTENT
The return value is an XQuery document node with the text node as its child.
RETURNING SEQUENCE
The return value is a sequence with the text node as its only item. This is the default.