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!

show row data into columns

728768Sep 12 2013 — edited Sep 13 2013

Hi guys

i have data coming in multiple rows and want to show same data in columns like multiple colours per product. colour are fixed in numbers i.e only three colours are there per product not more than that..

sample data is like this

id product_name colour

101 A red

101 A black

101 A Green

result required:-

id product_name colour1 colour2 colour3

101 A red black green

thanks & Regards

This post has been answered by padders on Sep 13 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2013

Added on Sep 12 2013

33 comments

573 views