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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pivoting rows into columns in Oracle 10g

963637Sep 21 2012 — edited Sep 21 2012

Hi,

I want to pivot rows into column in some optimal way.
I don't want to go with the DECODE option as the number of columns can be more than 200.
i have also tried the transpose logic which is making the pl/sql block too huge.

can i directly query the database for the desired output instead of storing the data into some arrays and displaying rows as columns?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2012

Added on Sep 21 2012

8 comments

8,967 views