Oracle® Database SQL Language Reference 11g Release 1 (11.1) Part Number B28286-01 |
|
|
View PDF |
A NULL
condition tests for nulls. This is the only condition that you should use to test for nulls.
null_conditions::=
Table 7-10 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 ORDER BY last_name; |