Re: Pivot Tables

From: <alvie_at_my-deja.com>
Date: Wed, 24 Jan 2001 20:51:45 GMT
Message-ID: <94nf8s$qag$1@nnrp1.deja.com>

Can I reference that cursor in a VIEW? Basically I've got a situation where I need to create a row from columns that I JOIN into (based on the newly created row) in a VIEW.

In article <94ndst$ook$1_at_nnrp1.deja.com>, christianboivin_at_my-deja.com wrote:
> 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/
>

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