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!

Multiple Rows into 1 Row

868887Jun 14 2011 — edited Jun 14 2011
Hello all,

I am trying to merge data from multiple rows--but all the same column--to a single row. For instance, if I have:

Row 1: a b
Row 2: b c

I want to end up with result set:

Row 1: a b b c

Any thoughts?
Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2011
Added on Jun 14 2011
3 comments
762 views