Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Conditions, 7 of 11
A NULL
condition tests for nulls.
null_condition::=
null_condition
Table 5-9 lists the null conditions.
Condition | Operation | Example |
---|---|---|
IS [NOT] NULL |
Tests for nulls. This is the only condition that you should use to test for nulls. See Also: "Nulls". |
SELECT last_name FROM employees WHERE commission_pct IS NULL; |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|