Re: Column into Row

From: ddf <oratune_at_msn.com>
Date: Thu, 3 Sep 2009 09:54:00 -0700 (PDT)
Message-ID: <86fa2d2d-022a-4884-ad28-5d1093f3f231_at_y42g2000yqb.googlegroups.com>

On Sep 3, 8:36 am, keeri <ck.keer..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Read here:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:419593546543

David Fitzjarrell Received on Thu Sep 03 2009 - 11:54:00 CDT