NULL conditions

A NULL condition is the only condition used to detect NULLs.

Syntax

The syntax of NULL conditions is as follows:

expr IS [ NOT ] NULL

For more information about NULLs, see NULL value.

Examples

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