NULL is a special Oracle value that may be applied to all data types. It means that the value is unknown.

Therefore:

• Any IF condition evaluation with NULL will always return False
• a NULL value must be tested for especially, in SQL, as thus: IS NULL or IS NOT NULL
• Oracle provides for functions to handle Null conditions like NVL