Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "= null" & "is null"
Norris wrote:
> What is the difference between = null and is null?
>
> --
> --
> http://www.washington.edu/pine/faq/
Nothing can "= null" because null is never equal to anything -including null. Therefore it would be absurd to do something like:
select sysdate
from dual
where null = null;
or
select sysdate
from dual
where null != null;
both will produce the same results but the results are wrong in both cases.
Therefore, if you want to test for null the only way to do is is via 'is null' or 'is not null'.
Ken Received on Thu Aug 26 1999 - 07:14:12 CDT