Re: Question on Decode Versus Case

In my opinion I can't see Oracle dropping DECODE. It would break too many existing apps and I can't see what benefit there would be. However, CASE is much more flexible, more readable and not completely Oracle-specific (if that matters to you).

If you are going to be using DECODE a lot, the following might prove helpful too.

http://doug.burns.tripod.com/decode.html (or doc or pdf, whichever you prefer)

Cheers,

--
Doug Burns - Oracle DBA

dougburns_at_yahoo.com

http://doug.burns.tripod.com
http://oracledoug.blogspot.com