[thelist] [SQL] Case vs Decode

Mark M thelist at lists.evolt.org
Mon Mar 3 17:44:00 2003


Heya everyone,

Just as a matter of interest - anyone know of any articles / have any comments on
when and where it is better to use a CASE statement, as opposed to DECODE?

(I'm using Oracle... in case you wondered)

Is i just a case of readability, or is there more to it?

Cheers,

Mark