Re: Column into Row

From: keeri <ck.keerthi_at_gmail.com>
Date: Thu, 3 Sep 2009 06:36:00 -0700 (PDT)
Message-ID: <0b1d4b56-8502-48c0-8534-0ba0f7cdeeab_at_k13g2000prh.googlegroups.com>

On Sep 3, 6:11 am, ddf <orat..._at_msn.com> wrote:
> On Sep 3, 6: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
>
> Knowing the version of Oracle you're using helps tremendously as the
> options for providing that output vary with the age of the release.
>
> Post  your version to 4 or 5 numbers so someone can help you without
> guessing.
>
> David Fitzjarrell

Hi David,

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

Can anyone help .. ?

Thanks,
Keerthi C Received on Thu Sep 03 2009 - 08:36:00 CDT