Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pivot Tables

Re: Pivot Tables

From: <alvie_at_my-deja.com>
Date: Fri, 26 Jan 2001 18:14:40 GMT
Message-ID: <94seq7$4d0$1@nnrp1.deja.com>

Does anyone have this article? I cant find it on the web.

> > > 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
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 12:14:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US