The Library is currently in the process of being upgraded from Oracle Database Version 220.127.116.11 to 18.104.22.168.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Have you viewed the Library's main Table of Contents? If not ... [Click Here]
... scroll down the page and you will find links to the largest collection of Oracle Database demos on the net.
XMLQuery returns query results as XML. XMLTable returns results as relational data.
SELECT <column_list>, XMLQuery (
'for $i IN <record_end_tag>
where $i<item_end_tag> = <value>
order by $i<item_end_tag>
PASSING BY VALUE <xml_record_column>
RETURNING CONTENTS) <returning_column_alias>
Note: What is within the parentheses is case sensitive and you can not use Upper Case or InitCap for commands.
col column_value format a50
FROM person_data a,
'for $root in $date
where $root/PDRecord/PDName = "Daniel Morgan"
passing a.person_data AS "date") t;