Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DECODE and boolean-expression
"Alexander Mueller" <millerax_at_hotmail.com> wrote in message
news:43d68d08$0$21030$9b4e6d93_at_newsread2.arcor-online.net...
> Hi
>
> how can i use Decode if I want to evaluate an boolean expression?
> I want to convert an Access-SQL-Statement using IIF:
>
> IIf (Val > 100, ID, 9999) As ID
>
> How can I check if Val is bigger then 100 with Decode,
> my pseudo code looks like:
>
> Decode (Val > 100, true, ID, 9999) As ID
>
> but what's the equivalent for 'true' in PL/SQL?
>
> Mfg,
> Alex
CASE expression (depending on your DB version)
otherwise, use a DECODE on a SIGN expression (returns -1, 0, or 1 and can be used to kludge if-then-else logic)
++ mcs Received on Tue Jan 24 2006 - 14:27:16 CST