René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

XMLSequence [Oracle SQL]

XMLSequence (xml-type-instance)
XMLSequence (sys-refcursor-instance
XMLSequence (sys-refcursor-instance, 'format')

An example

select
  value(tab).getStringVal() "Some Col"
from
  table (
    XMLSequence(extract (
     XMLType('<things><item>car</item><item>bottle</item><item>chair</item></things>'),
     '/things/item')
    ) 
  ) tab;
Some Col
-----------------------------
<item>car</item>
<item>bottle</item>
<item>chair</item>