Re: Column into Row

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 3 Sep 2009 06:33:05 -0700 (PDT)
Message-ID: <59ed9562-fddd-4d64-a57d-4f6b81b45748_at_v36g2000yqv.googlegroups.com>



On Sep 3, 7:45 am, keeri <ck.keer..._at_gmail.com> wrote:
> Hi all,
>
> I have a table like this ..
>
> Name     ID
> --------     ----
> A            1
> B            2
> C            3
> D            4
> E            5
>
> If table is queried , I need like ..
>
> Name     A     B      C ..
> ID           1     2       3 ..
>
> Can anyone help me on this issue ?
>
> Thanx,
> Keerthi c

David is right. We need a little more information. Basically what you probably want to do is called pivoting. There have been several posts on the subject in the past. There are several approaches but some require more recent versions of Oracle. Indeed 11g includes a command to pivot data. You can seach the archives to find some possible solutions.

HTH -- Mark D Powell -- Received on Thu Sep 03 2009 - 08:33:05 CDT

Original text of this message