Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
A NULL
condition tests for nulls. This is the only condition that you should use to test for nulls.
Table 6-9 lists the null conditions.
Type of Condition | Operation | Example |
---|---|---|
IS [NOT] NULL |
Tests for nulls.
See Also: "Nulls " |
SELECT last_name FROM employees WHERE commission_pct IS NULL; |