What is the difference between decode and case function?

Answer 1

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.

Answer 2

Thanks