SQL - NULL vs IS NULL? | Oracle Community

NULL is not a value it's like a state. That's why you must use the IS [NOT] NULL syntax. If you prefer ...

community.oracle.com