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
Screen 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