SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query

Karthik.KJul 3 2009 — edited Jul 7 2009

Gurus,

I have a table column which contains the following value as comma seperated like

Column1

ABC,DEF,GHI,JKL,MNO,.....

I need the output like

ABC
DEF
GHI
JKL
MNO
...

I need a generic query to get this output. Can anyone help me out for this?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2009

Added on Jul 3 2009

30 comments

1,422 views