Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "= null" & "is null"
Remember the concept that Null is never 'EQUAL' to everything, even itself.
So, = NULL means nothing
If you compare two values, say a = b, and the two values are nullable, use
Nvl() function
Norris wrote in message <7q3936$37f$2_at_imsp009a.netvigator.com>...
>What is the difference between = null and is null?
>
>--
>--
>http://www.washington.edu/pine/faq/
Received on Thu Aug 26 1999 - 22:52:05 CDT