Prepare for your Next Interview
This is a discussion on Uniqueness of Decode command? within the Oracle forums, part of the Databases category; 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 ...
|
|||
|
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. |
| Sponsored Links |
|
|||
|
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.
__________________
Lack of WILL POWER has caused more failure than lack of INTELLIGENCE or ABILITY. -sutnarcha- Last edited by sutnarcha : 05-25-2007 at 05:54 AM. |
|
|||
|
Re: Uniqueness of Decode command?
Quote:
some more advantages of Decode command over "If-then-else" stmt. Regards |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Want to know about this command | christia | Windows | 2 | 11-01-2006 10:09 AM |
| Can you tell the command | christia | Unix/Linux | 1 | 09-09-2006 05:00 PM |
| Can you brief about this command | RyanJames | Unix/Linux | 1 | 08-31-2006 04:29 PM |
| Help me with the command | joel | SQL | 1 | 07-23-2006 12:29 PM |
| Decode in SQL | timmy | Oracle | 2 | 07-16-2006 12:20 PM |