This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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

---

Notes #

Click to create a new notes page