Uniqueness of Decode command?
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.
1 Attachment(s)
Re: Uniqueness of Decode command?
Check the attachment for my reply.
This code may contain sintax errors. It may not work on PL/SQL. It can be looked at as a psudocode.
Thnx.
Re: Uniqueness of Decode command?
[QUOTE=sutnarcha;12457]Check the attachment for my reply.
This code may contain sintax errors. It may not work on PL/SQL. It can be looked at as a psudocode.
Thnx.[/QUOTE]
Could you pls gimme another example for this and
some more advantages of Decode command over "If-then-else" stmt.
Regards