Kirk Evans Blog

.NET From a Markup Perspective

FOR XML and OPENXML using Oracle

Ever wished that Oracle had something like SQL Server’s FOR XML and OPENXML keywords?  It doesn’t have it, but you can return XML from Oracle as a CLOB using XSU, and shred an XML string into relational tables using the XMLType. For more information:

Thanks to Sreedhar for this tip.