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 explicitly, 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 pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation