Re: Pivot Tables

In article <3A6FB567.8FBB09F9_at_exesolutions.com>,   "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:
> > 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
>
>

Can you post a small exemple of this

Thanks

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 09:51:35 CST