Re: [Q] Porting SQL to Oracle

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 12 Jun 2003 08:11:26 +0000
Message-ID: <bc95m8$4dj$2@ctb-nnrp2.saix.net>

TurkBear wrote:

> Not religious, just the use of English..
> '=' is not the same as 'IS' ...
>
> One tests for equality ( that is, the same value) while the other tests
> for existence...
>
> So while NULL cannot be equal to anything, even itself, it can, an often
> does, exist - so test for its existance..ergo, IS or IS NOT ....

Exactly. This man deserves them pointy Vulcan ears. (and also likely have experience with OO programming)

--
Billy

Received on Thu Jun 12 2003 - 03:11:26 CDT