XMLPARSE Syntax - Advanced SQL Engine - Teradata Database

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.