Skip to content

Instantly share code, notes, and snippets.

@terrancesnyder
Created July 5, 2011 21:48
Show Gist options
  • Save terrancesnyder/1066051 to your computer and use it in GitHub Desktop.
Save terrancesnyder/1066051 to your computer and use it in GitHub Desktop.
Oracle XML to Temp Table
SELECT extractvalue(column_value, '.') as record_id
FROM TABLE(XMLSequence(XMLTYPE(
'<list>
<id>34123121234</id>
<id>12312221233</id>
</list>').extract('//id'))) t
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment