Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with select statement (pivot table?)
> >>--
> >>Daniel A. Morgan
> >>University of Washington
> >>damorgan_at_x.washington.edu
> >>(replace 'x' with 'u' to respond)
>
> 1. Please do not top post.
> 2. In Oracle use the DECODE or CASE statement to pivot.
>
> Examples of DECODE and CASE used to pivot can be found at:
> http://www.psoug.org
> click on Morgan's Library
> click on DECODE
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Thanks for the examples. I am still a little confused. The crosstab example is converting values into columns. I want to do the opposite. I want to convert columns into values. Thanks...
AL Received on Mon May 02 2005 - 11:38:33 CDT