Sometimes Difference between CASE and DECODE in Oracle is a little puzzling as to what to use and when.
While working with data you may need to write SQL for complex reporting which requires CASE and DECODE functionalities. Most of the PL SQL developers have this question of when to use CASE and ...
