Re: Pivot table Query - Need help in building correct logic

From: Pankaj <harpreet.noni_at_gmail.com>
Date: Thu, 3 Dec 2009 16:28:26 -0800 (PST)
Message-ID: <b5668e45-f7af-480e-9335-41bb0b40274e_at_x15g2000vbr.googlegroups.com>

On Dec 3, 7:08�pm, Peter Nilsson <ai..._at_acay.com.au> wrote:
> On Dec 4, 10:36�am, Pankaj <harpreet.n..._at_gmail.com> wrote:
>
>
>
>
>
> > Greetings,
>
> > I have a table format as below
>
> > sec � � � value � � � �type
> > X � � � � �100 � � � � � T
> > X � � � � �200 � � � � � S
> > Y � � � � 300 � � � � � �T
> > Y � � � � 400 � � � � � �S
> > Z � � � � �500 � � � � � T
> > Z � � � � �600 � � � � � S
>
> > I want to pivot the above to somethin as below
>
> > sec � � T � � � � � S
> > X � � � �100 � � � �200
> > Y � � � �300 � � � 400
> > Z � � � �500 � � � �600
>
> > Can anyone please advise. I have been looking for pivot
> > logic for some time but could not figure this out.
>
> � <http://www.lmgtfy.com/?q=oracle+pivot+query&l=1>
>
> --
> Peter- Hide quoted text -
>
> - Show quoted text -

Thanks Peter. As I said earlier, I did tried google but could not found the correct way of implementing the logic. Also, the domain for sec is not fixed. I have just shown X, Y and Z but there could be more.

Thanks for your time. Received on Thu Dec 03 2009 - 18:28:26 CST