XMLEXTRACT Method | XML Data Type | Teradata Vantage - XMLEXTRACT - 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ā„¢

Evaluates a query against the XML instance.

Syntax

XMLEXTRACT (
  [ filterExpr, ]
  query,
  nsmap
)
filterExpr

An optional filter expression that allows for streamed evaluation of the query expression.

filterExpr is required if the query is being evaluated over a large XML value.

query
The XPath or XQuery query string.
nsmap
Namespace declarations.