Skip to Main Content

SQL Developer

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 multiple values in to a single cell

idmr2Oct 3 2012 — edited Oct 18 2012
Hi friends,
I have a problem with displaying the data in my table.

My table contains following data,

Id role rank
1 H.R 2
1 T.L 1
2 P.M 1
2 Manager 2
..............

like above i have my data....
now i want to display my data like as follows,

id role rank
1 H.r , T.L 1,2
2 P.M , Manager 1,2
......................

like the above scenario i have to display multivalued attributes into a single cell based on 'id'

...Help Me to solve this problem

Thanks in advance,
Nani

Edited by: 962874 on Oct 3, 2012 3:44 AM

Edited by: 962874 on Oct 3, 2012 3:45 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2012
Added on Oct 3 2012
2 comments
776 views