Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library
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;