I want to retrieve the result set from an XML document in a select query. like
Select [column_name] from XMLdoc;
is there any way for doing this in Oracle. I saw the tutorials and docs, but there are plenty of XML related functions which confused me a bit. A suggestion with the direct XML function for the above requirement will be highly appreciated..