Skip to Main Content

APEX

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!

Concatenate Multiple Rows Into One Unique Identifier

YashaswiniJan 22 2011 — edited Jan 22 2011
Hi All,

I need to concatenate multiple rows into one unique identifier

So, my unique identifiers are Name and email_id column.


It is 1:M relationship like same name and email_id can have n number of different products, now i should


So, let's say Name=xyz and email_id=xyz@xyz.com has 5 rows with different product info for them.

#Name #email_id # product

xyz xyz@xyz.com Ora
xyz xyz@xyz.com sql
xyz xyz@xyz.com siebel
xyz xyz@xyz.com erp
xyz xyz@xyz.com crm

My end result would be after concatenation (having / as delimeter between each concatenated row):

#Name #email_id # product
xyz xyz@xyz.com Ora/sql/siebel/erp/crm

Help please, after many attempts I can't seem to get it to work. Thank in advance

Edited by: user13080645 on 22-Jan-2011 07:33
This post has been answered by ATD on Jan 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2011
Added on Jan 22 2011
6 comments
2,129 views