Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Standard Edition One
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 18, 2013 12:26 PM by
need to Convert Comma separated data in a column into individual rows from
Oct 19, 2011 10:39 AM
I need to Convert Comma separated data in a column into individual rows from a table.
Eg: JOB1 SMITH,ALLEN,WARD,JONES
OUTPUT required ;-
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.
This content has been marked as final.
Show 1 reply
Re: need to Convert Comma separated data in a column into individual rows from
Oct 18, 2013 12:26 PM
in response to
Go for ETL solution. There are couple of ways to implement.
If helps mark