For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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;