Back to Papers
 
 

Introduction

Definitions

Basic Usage

Logic-dependent Aggregation

An Interlude

Logic-dependent Aggregation (contd)

Pivot Tables and Multi-part Logic

Beyond Equality

Conclusion

Additional Resources

Please note this page has moved to http://oracledoug.com/case10.html. You will be redirected in 5 seconds but it would be better to update your bookmarks ;-)

Oracle Documentation

Sample Schemas

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10771/toc.htm

CASE Expressions

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/expressions004.htm#sthref809

Related Articles

Sample Schemas article on OTN

http://www.oracle.com/technology/oramag/oracle/02-jul/o42schema.html

Original DECODE paper

http://doug.burns.tripod.com/decode.html

Daniel Morgan’s DECODE and CASE reference

http://www.psoug.org/reference/decode_case.html

AskTom thread on deciphering execution plans

http://asktom.oracle.com/pls/ask/f?p=4950:8:10404375799506113809::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:231814117467,

Acknowledgments

I’d like to thank the following people for sparing some of their time to read through the paper, checking it for accuracy and making some very useful suggestions for improvement. As usual, the final decisions and all of the mistakes

Andrew Campbell, Sun Microsystems
Colin Garside, BUPA
John Gilroy, Ask Jeeves
Jeffrey Kemp
Jari Kuhanen, Sun Microsystems