Re: tricky SQL

bcjm wrote:

> Since the value of the classes are unlimited, the pivoting result will
> have unlimited column of classes. Using DECODE is not an option either
> since the value are unlimited. Any other suggestions?

Didn't the original post say 3 was the max?

Anyway ... Tom Kyte has addressed this so take a visit to http://asktom.oracle.com.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)