17.10 - XMLPARSE Syntax - 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)
XMLPARSE (
  { DOCUMENT | CONTENT }
  string_value_expr
  { PRESERVE | STRIP }
  WHITESPACE
)

Syntax Elements

DOCUMENT
The function returns an XML document node.
CONTENT
The function returns an XQuery document node.
string_value_expr
The string value to be parsed.
The data type of string_value_expr is CLOB or VARCHAR.
If string_value_expr is NULL, the function returns NULL.
PRESERVE WHITESPACE
White space is preserved during parsing.
STRIP WHITESPACE
White space is removed during parsing.