Re: calculated value in a DECODE statement

Guido Konsolke wrote:

> "DA Morgan" wrote...
> > You can use CASE ... but why make this more difficult than need be?
> >
> > Why not:
> >
> > IF numfield > 0 THEN
> > ...
> > ELSE
> > ...
> > END IF;
> >
> > Daniel Morgan
> >
>
> Hi Daniel,
>
> please forgive me: IF - ELSE - END IF in SQL?
> (OP wrote: '... Oracle sql front ender...').
> I suppose in a version > 8.1.7.0?
> I have no chance to look in the docs online since our
> firewall broke down. So please enlighten me (meanwhile
> I'll have a 25 year old Glenfarclas ;-)).
>
> Greetings,
> Guido

No not in any SQL. But in an anonymous block or in PL/SQL. Unfortunately SQL is used here many times as a synonym for PL/SQL so it is hard to know what OP's may be thinking.

Daniel Morgan Received on Tue Mar 18 2003 - 10:08:34 CST