Skip to Main Content

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!

Concat the Rows for Same ID

642000Jul 5 2012 — edited Jul 5 2012
Hi All,

I want to merge rows in one row for e.g column 1, column 2, column 3, column 4 are same ,but column 4 and column 5 are diffrent, I want to merge in one row.

Below is data:

column1 column2 column3 column4 column5
123 abc xyx a b
123 abc xyx e k
123 abc xyx w h
124 sss ttt r f
124 sss ttt q p
124 sss ttt z m

Below is the Result:

final row
123 abc xyz abekwh
124 sss ttt rfqpzm

Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2012
Added on Jul 5 2012
11 comments
1,510 views