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...
skip to main |
skip to sidebar
In Memory of Amy Morton Workman 1971-2014
Meanderings of one who is lucky enough to have her avocation be her vocation.
Pages
About Me
Disclaimer
All content and technical information contained on the site is the professional opinion of the author and is in no way connected to a current or any prior professional affiliations/employment.
Fight Carcinoid Cancer!
In Memory of Amy Morton Workman 1971-2014
Books
Enkitec Blogs & Links
Links & Blogs
Blog Archive
-
▼
2008
(57)
-
▼
Jun 2008
(12)
- Plan execution statistics
- What technological advances provide
- Kindle update
- Oracle Performance Problems and Root Canals
- MacBook convert
- I only thought it was the future of presenting...
- My new toy
- Optimizer NOWORKLOAD statistics
- The Future of Presenting?
- Famous last words
- Don't do work you don't have to do
- PIVOT/UNPIVOT
-
▼
Jun 2008
(12)
Proud Member
2 comments:
You might want to link directly to Tom's post here, as the next time he blogs your link will no longer point to his Pivot post.
Also, I have a post on the 11g Pivot syntax here. It's not near as cool as Tom's, but might be easier for people to get their brains around so they can better appreciate just how cool Tom's solution is.
Thanks Tyler. I didn't catch that I'd pointed to Tom's main site and not the specific article. Also, thanks for the link to your post on the Pivot syntax. Excellent!
Post a Comment