What is the difference between decode and case function?
Generally, not much. DECODE was introduced before CASE. The latter introduces newer features as it is a statement rather than a function, so you can use it in Where clauses and PL/SQL. CASE is easier to read. Therefore CASE is recommended over DECODE.