21.24.NULL | ||||
21.24.1. | All logical operations (including NOT) involving NULL always return NULL | |||
21.24.2. | variable:=nvl(value1,value2); | |||
21.24.3. | In PL/SQL the Boolean expression NULL=NULL evaluates to FALSE. | |||
21.24.4. | Short-circuit evaluation with conditional structures. | |||
21.24.5. | Compare with NULL value for equality | |||
21.24.6. | Compare with NULL value for non-equality | |||
21.24.7. | Compare NULL value and OR operator | |||
21.24.8. | Compare with NULL value and 'AND' operator | |||
21.24.9. | Compare Integer value with NULL value | |||
21.24.10. | Use IS NULL in IF statement | |||
21.24.11. | Use NVL in IF statement to deal with the NULL value comparison |