Skip to Main Content
Forums

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!

Convert a row into columns

758537Jun 1 2010 — edited Jun 1 2010
Hello Experts,

I have data that looks like :-

field1 field2
1 a,b,1,c,3,4
2 e,3,4,d,f,g

I want a query which would output the data as
field1 field2
1 a
1 b
1 1
1 c
1 3
1 4
2 e
2 3
2 4

etc

Any help would be appreciated.

Thank you
This post has been answered by BluShadow on Jun 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2010
Added on Jun 1 2010
6 comments
1,385 views