Re: Pivot Tables

From: <christianboivin_at_my-deja.com>
Date: Wed, 24 Jan 2001 20:28:27 GMT
Message-ID: <94ndst$ook$1@nnrp1.deja.com>

Hi
The better way, i think !
is to create a stored proc that return
a generic ref cursor ...

Regards
Chris

In article <94ncmc$nj1$1_at_nnrp1.deja.com>, alvie_at_my-deja.com wrote:
> Hi
> I have a table that looks like this:
>
> product_id product_name
> --------------------------------
> 1 item1
> 2 item1
> 3 item1
>
> Is there a way using SQL to make it look like this:
>
> product_name Alias1 Alias2 Alias3
> ---------------------------------------------------
> item1 1 2 3
>
> thanks
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 14:28:27 CST