Re: Help needed for an IF ..THEN...ELSE Construction

Of course, there's always PL/SQL...

~bob

Sybrand Bakker wrote:
> 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.
>
> 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...
> > 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 - 20:39:44 CST