Tuesday, March 27, 2012

Oracle Quoted CSV to Rows/Select from CSV

Had to share this awesome little tidbit. In 11g:
select extractvalue(column_value,'text()') vals from xmltable('"this","is","my","csv"');

vals
this
is
my
csv
Thanks Laurent Schneider for your original post of this here!

No comments:

Post a Comment