1 Reply Latest reply: Oct 18, 2013 7:26 AM by Srini VEERAVALLI RSS

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

    user766995
      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