It takes some complex coding – forcing ranges of data into discrete form – to achieve the same effect with DECODE.Īn example of putting employees in grade brackets based on their salaries. CASE is capable of other logical comparisons such as etc. CASE can work with logical operators other than ‘=’ĭECODE performs an equality check only. We’ll go through detailed examples in this article.ġ. There is a lot else CASE can do though, which DECODE cannot. CASE was introduced in Oracle 8.1.6 as a standard, more meaningful and more powerful function.Įverything DECODE can do, CASE can.
Databases before Oracle 8.1.6 had only the DECODE function.
