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!

Dynamic column to row (pivot) with no aggregation

abe50Feb 14 2012 — edited Feb 14 2012

Hi,

I have been scouring the forum the last couple of days for dynamic pivoting hints but couldn't find a solution. I really appreciate any tips to guide me to the right direction.
I want the last two columns dynamically converted the last as rows.

Oracle version: 11gR2

server     client   errorset    Date

ms003      apex1      256       02/01/2012        
ms001      apex2      324       01/15/2011
me002      sql001      0        03/11/2011
me001      sql003     12        02/01/2012
.              .        .               .
.              .        .               .
.              .        .               .
.              .        .               .


convert it the following :

server     client      02/01/2012  01/15/2011  03/11/2011 .  . . .  .

ms003      apex1      256        
ms001      apex2                  324
me002      sql001                                       0
me001      sql003     12         
.              .       
.              .                       
.              .        
.              .

Is this possible?

Thanks,
-Abe

Edited by: abe50 on Feb 14, 2012 11:46 AM

This post has been answered by Frank Kulash on Feb 14 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2012

Added on Feb 14 2012

#query

3 comments

4,264 views