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!

Display comma separated column values .

n2813Aug 16 2013 — edited Aug 20 2013

Hi Everyone ,

Table 1

col1col2
id1name1
id2name2
id3name3

Table 2

col1col2
rq11
rq23,2
rq32,3

Result Table

col1col2
rq1 name1
rq2name3,name2
rq3name2,name3

Based on table 1 and table 2 need to create a view to produce a result table.

Experts any thoughts  !!!!
This post has been answered by Karthick2003 on Aug 16 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2013
Added on Aug 16 2013
26 comments
6,477 views