ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Returns query results as XML. XMLTable returns results as relation data.
SELECT <column_list>, XMLQuery (
'for $i IN <record_end_tag>
WHERE $i<item_end_tag> = <value>
ORDER BY $i<item_end_tag>
RETURN $i<item_end_tag>
PASSING BY VALUE <xml_record_column>
RETURNING CONTENTS) <returning_column_alias>
FROM <table_name>;
Note: What is within the parentheses is case sensitive and you can not use Upper Case or InitCap for commands.
SELECT person_id, XMLQuery('FOR
$i IN /PDRecord
WHERE $i /PDName = "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName eq "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Greater Than
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName > "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName gt "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Greater Than Or Equal To
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName >= "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName ge "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Less Than
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName < "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName lt "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Less Than Or Equal To
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName >= "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName le "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Not Equals
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName != "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName ne "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
