A blog to help me remember what in the hell i've done and what not to do again. ever. Maybe you'll learn from my mistakes or epiphanies.
Blog topics include SQL, T-SQL, Google, Windows, Visual Basic, Python, C#, etc.
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