Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed for an IF ..THEN...ELSE Construction
The absence of range expression is not really a problem, as it can be
replaced by the SIGN function
, like SIGN(ordervol - 1000).
I admit it looks ugly, but it works.
There's no alternative to decode.
Hth,
Sybrand Bakker, Oracle DBA
M. Pfadenhauer <markus.pfadenhauer_at_studtum.lrz-muenchen.de> wrote in message
news:8bbb0i$a94$1_at_wsc10.lrz-muenchen.de...
> Hi,
>
> is there a way to use an 'IF..THEN..ELSE' construction in SQL. I am using
> Oracle8.
>
> something like this should be done:
>
> select ID as custID, IIF( ordervol > 1000 ; 'fine' ; 'bad' ) as foo
> from customer
>
> the only thing i found in the docs is the DECODE statement. But there is
no
> way to use rangeexpression....
>
> thanx for any advice,
>
> markus.pfadenhauer_at_studtum.lrz-muenchen.de
>
>
>
>
Received on Wed Mar 22 2000 - 14:57:12 CST