Database Reference
In-Depth Information
Figure 17.16
Demonstrating
EXTRACT,
EXISTSNODE,
and a Single-Value
Pattern Match.
SELECT ID, EXTRACT(XML, '/Artist[City="Vienna"]') FROM XML
WHERE EXISTSNODE(XML, '/Artist[City="Vienna"]') = 1;
SELECT ID, EXTRACT(XML, '/Artist[City="Vienna" or
City="Boston"]')
FROM XML WHERE EXISTSNODE(XML, '/Artist[City="Vienna"
or City="Boston"]') = 1;
Figure 17.17
Demonstrating
EXTRACT,
EXISTSNODE,
and a Multiple-
Value Pattern
Match.
That covers data retrieval for XML documents in Oracle SQL.
17.2.2.3
Changing and Removing XML Document Content
An XML document is stored internally as a CLOB or large binary text
object. As a result, updating the contents of an XML document in an
Search WWH ::




Custom Search