Re: I can't believe I can't use IIF anymore!?!

From: Hakan Eren <heren_at_home.com>
Date: Wed, 23 Feb 2000 22:09:52 GMT
Message-ID: <38B45AF3.EC10FAD8@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:09:52 CST