Re: Pivot Tables

> 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

You can pivot Oracle data using the DECODE function.

Daniel A. Morgan Received on Wed Jan 24 2001 - 23:11:03 CST