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 explicity, in SQL, as thus: IS NULL or IS NOT NULL
- Oracle provides for functions to handle Null conditions like NVL
- UserCalcs can test for Null conditions using the EQNL Operator