Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: I can't believe I can't use IIF anymore!?!
Thank you very much, I will look a that.
Patrick
Hakan Eren wrote in message <38B45AF3.EC10FAD8_at_home.com>...
>SELECT DECODE(SIGN(score-400), 1, 'SomeoneElse', 0, 'Patrick', -1,
>'Patrick') as msg FROM DUAL;
>
>will work
>
>sample:
>
>SQLWKS> SELECT DECODE(SIGN(399-400), 1, 'SomeoneElse', 0, 'Patrick', -1,
>'Patrick') as msg FROM DUAL;
>MSG
>-------
>Patrick
>1 row selected.
>SQLWKS> SELECT DECODE(SIGN(400-400), 1, 'SomeoneElse', 0, 'Patrick', -1,
>'Patrick') as msg FROM DUAL;
>MSG
>-------
>Patrick
>1 row selected.
>SQLWKS> SELECT DECODE(SIGN(401-400), 1, 'SomeoneElse', 0, 'Patrick', -1,
>'Patrick') as msg FROM DUAL;
>MSG
>-----------
>SomeoneElse
>1 row selected.
>
>Hakan
>
>Patrick Joyal wrote:
>>
>> you know, like :
>>
>> select IIF (Score >400, 'Congratulations!', 'Loser!') as Message ;
>>
>> to my surprise, it doesn't work in Oracle
Received on Wed Feb 23 2000 - 16:22:16 CST