For how many years have you been working
with physical servers? Software Defined Servers can improve performance and
security while lowering complexity and cost. With Software Defined Servers
you define servers with an optimum configuration to your environment rather
than being memory starved and cpu over-provisioned. Find out how you can
improve your computing environment with
TidalScale. your friends.
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;