PIVOT/UNPIVOT

Oracle 11 has introduced new functionality to handle pivoting data. The PIVOT and UNPIVOT functions are the coolest thing I've seen in a long time. Today, Tom Kyte blogged an example case using this new feature. Very, very cool.

Now all I wish was that I would actually get to use Oracle 11 more often. Trying to accomplish what Tom did in a pre-11 version of Oracle is not fun. And I really, really like fun...