Comparision of Decode and case statement
Both are same
case can check for non equality operator but decode checks for equality operator
decode can be used for comparing value of one variable/condition. but case can check for multiple conditions
case can not be used in where clause. but decode can be used.