Re: calculated value in a DECODE statement

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 18 Mar 2003 08:16:17 +0100
Message-ID: <1047971699.93446@news.thyssen.com>

"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 Received on Tue Mar 18 2003 - 01:16:17 CST