Re: NULL comparisions
From: NAMIEB <namieb_at_aol.com>
Date: 15 Oct 1999 00:36:22 GMT
Message-ID: <19991014203622.07600.00000438_at_ng-fi1.aol.com>
Date: 15 Oct 1999 00:36:22 GMT
Message-ID: <19991014203622.07600.00000438_at_ng-fi1.aol.com>
Nulls are not a "value", so you can't compare them to anything. You should always test for the null first or use the nvl function.
( ((var1 is null) and (var2 is null)) or (var1 = var2) ) Received on Fri Oct 15 1999 - 02:36:22 CEST