Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pivot Tables
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