Re: Oracle For Fun

From: Jeff <jeff_at_work.com>
Date: Tue, 03 Feb 2004 13:36:55 GMT
Message-ID: <bvo85m$mu8$1@cronkite.cc.uga.edu>

In article <YBCTb.205971$I06.2284013_at_attbi_s01>, "VC" <boston103_at_hotmail.com> wrote:

>
>
>Care to elaborate on "doesn' handle null values ? Just being curious...

I mean that it does nothing to handle NULL values passed to it. I mean that it does not return TRUE or FALSE when a NULL value is passed--it returns NULL. Why does this matter? Because NOT NULL <> FALSE. I guess a design decision might be involved where you'd want it to return NULL for NULL values passed, but that wasn't specified... and looking at your test program, it wasn't for you either.

> 5 if f1(l.x) then l_str := 'valid'; else l_str := 'not valid'; end if;

Changing this line to:

if NOT f1(l.x) then l_str := 'not valid'; else l_str := 'valid'; end if;

.. and you'll get different results when you shouldn't. THAT is what disqualifies translate3. Received on Tue Feb 03 2004 - 07:36:55 CST