Data Management

Interesting SQL Question, Pivot 1 column into multiple rows

This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL.


A couple of days ago, a question was posted on one of the itToolbox.com email groups:


From: Brat

Subject: [oracle-sql-l] COnverting one field into multiple rows


Message:


How do I parse this one field in a table into multiple rows:


Field 1


1,2,3,4,56

Editor's Picks