Re: Pivot table Query - Need help in building correct logic
From: Peter Nilsson <airia_at_acay.com.au>
Date: Thu, 3 Dec 2009 16:08:44 -0800 (PST)
Message-ID: <7f418fd0-e1c2-4cf8-9ac2-ab2cf9d53622_at_v15g2000prn.googlegroups.com>
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.
Date: Thu, 3 Dec 2009 16:08:44 -0800 (PST)
Message-ID: <7f418fd0-e1c2-4cf8-9ac2-ab2cf9d53622_at_v15g2000prn.googlegroups.com>
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>
-- PeterReceived on Thu Dec 03 2009 - 18:08:44 CST