Dear all,

please tell me, what is the advantage of "DECODE" command over the
" IF-THEN-ELSE" statement in PL/SQL .

We can use " IF-THEN-ELSE" , why we are using "Decode" command?
What is the unique advantage for DECODE command and gimme the
difference between "DECODE" and " IF-THEN-ELSE" statement in pl/sql.

regards,
Prasath.