Re: Challenging rows to columns problem

From: at\ <_at_>
Date: Sat, 11 Jun 2005 10:11:58 +0200
Message-ID: <1118477519.e711b1d1efa05ac15fc7880a6ba5b650@teranews>

puneet.bansal_at_wipro.com wrote:
> Hi,
>
> Any idea how to achieve this? Col1 can have many values other than
> X,Y,Z and that many columns should come up in the final result. So the
> solution has to be generic that will work for any number of distinct
> values of col1.
>
> Thanks.
> Puneet
>

Read up on Pivot Queries:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:766825833740 Received on Sat Jun 11 2005 - 03:11:58 CDT