Null conditions

A null condition is the only condition used to detect for null values.

Syntax

The syntax of null conditions is as follows:

expr IS [ NOT ] NULL

For more information about null values, see Null values.

Examples

SELECT last_name FROM emp WHERE comm_pct IS NULL ORDER BY last_name;