When your conditions are simple and on EQUALITY check, you can use decode, Else if the condition are complex better use CASE.