Re: IS (NULL = 1) equal to NOT(NULL = 1)?

In article <321B7C7E.41C67EA6_at_unm.edu> Guy Bassan <gbassan_at_unm.edu> writes:
>From: Guy Bassan <gbassan_at_unm.edu>
>Subject: Re: IS (NULL = 1) equal to NOT(NULL = 1)?
>Date: Wed, 21 Aug 1996 15:15:42 -0600
 

>According to Oracle's documentation (which is occasionally correct),
>whenever you use NULL in any kind of function, you almost always get
>NULL back. (NULL = 1) is a function that returns a boolean: TRUE,
>FALSE or NULL. Usually booleans only have two values, but Oracle isn't
>constrained by silly conventions like that.

We even had some problems with FORM_SUCCESS and FORM_FAILURE (a built-in in FORMS4.5).
The manual tells us that it returns boolean and sometimes its value is NULL after calling a built-in (e.g. logon).

Volker Received on Wed Aug 28 1996 - 00:00:00 CEST