This discussion is archived
1 Reply Latest reply: Oct 18, 2013 5:26 AM by Srini VEERAVALLI RSS

need to Convert Comma separated data in a column into individual rows from

user766995 Newbie
Currently Being Moderated
Hi,

I need to Convert Comma separated data in a column into individual rows from a table.

Eg: JOB1 SMITH,ALLEN,WARD,JONES

OUTPUT required ;-

JOB1 SMITH

JOB1 ALLEN

JOB1 WARD

JOB1 JONES

Got a solution using Oracle provided regexp_substr function, which comes handy for this scenario.

But I need to use a database independent solution

Thanks in advance for your valuable inputs.
George

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points