CASE Expressions - Doug Burns' Oracle and ZX Spectrum ...

CASE was introduced in Oracle 8.1.6, however, and is a much better option because it is. More flexible than DECODE. Easier to read. ANSI-compatible (if that matters to you) However, CASE is essentially a better implementation of DECODE so the reasons for using either are similar. ................
................

In order to avoid copyright disputes, this page is only a partial summary.