Re: Column into Row

From: ddf <oratune_at_msn.com>
Date: Thu, 3 Sep 2009 06:11:37 -0700 (PDT)
Message-ID: <84b9a0f7-585b-4b38-b0cc-e46b2425f17a_at_x38g2000yqb.googlegroups.com>

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 Received on Thu Sep 03 2009 - 08:11:37 CDT