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!

Join tables based on comma separated values field

BalveerrApr 18 2017 — edited Apr 18 2017

Hi,

I have two tables. First table stores comma separated value from second table records.

1st table -

Header 1Header 2Header 3

custid

custname

market

111 abcx1,x2,x3,x4,x5,x6,x7,x9,x10,x11,x122,x13,x14
112ABC2
x1,x2,x3,x4,x5,x6,x7,x9,x10,x11,x122,x13,x14,x15,x16

2nd table -

Header 1Header 2
x1Meaning of x1
x2Meaning of x2
x3Meaning of x3
x4Meaning of x4
x5Meaning of x5
x6Meaning of x6
x7Meaning of x7
x8Meaning of x8
x9meaning of x9
x10Meaning of x10

I want to show like below -

Header 1Header 2Header 3

custid

custname

market

111 abcMeaning of x1,Meaning of x2,Meaning of x3,Meaning of x4,Meaning of x5,Meaning of x5,Meaning of x6,Meaning of x7,Meaning of x8,Meaning of x9,Meaning of x10
112ABC2Meaning of x1,Meaning of x2,Meaning of x3,Meaning of x4,Meaning of x5,Meaning of x5,Meaning of x6,Meaning of x7,Meaning of x8,Meaning of x9,Meaning of x10,Meaning of x11,Meaning of x12,Meaning of x13,Meaning of x14,Meaning of x15,Meaning of x16

Thanks,

Balveer
This post has been answered by Mustafa KALAYCI on Apr 18 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2017
Added on Apr 18 2017
11 comments
1,759 views