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 to Multiple columns

504410Jan 24 2008 — edited Jan 24 2008

I have a question. Hope you can please help me out here.

create table cb_test_col(
pID number(11),
CMID varchar2(50),
CTID number(11),
descr varchar2(50)
)

PID CMID CID DESCR

15896 118705 10378 SELLER
15896 118705 10379 SELLER
15896 118705 10380 SELLER
15896 118705 10381 SELLER
15896 118705 10382 SELLER

I need an output like this

PID CMID CID1 CID2 CID3 CID4 CID5
15896 118705 10378 10379 10380 10381 10382

Please help.

Thanks,
SP.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2008

Added on Jan 24 2008

7 comments

1,538 views