Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pivot Tables
> "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
Not really what I have is an article written by Joe Celko. The one time I used it was on a security system where I couldn't keep a copy of the code. Basically all you do is use DECODE and then alias the results to create the new column names.
Daniel A. Morgan Received on Thu Jan 25 2001 - 23:47:11 CST