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]