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.

  <http://www.lmgtfy.com/?q=oracle+pivot+query&l=1>

--
Peter

Received on Thu Dec 03 2009 - 18:08:44 CST