NULL predicate
The NULL predicate tests for null values.
Use the syntax:
single-valued-path-expression IS [NOT] NULL
Example: NULL predicate
e.name IS NULL
e.dept.name IS NOT NULL
e.dept IS NOT NULL
The NULL predicate tests for null values.
single-valued-path-expression IS [NOT] NULL
e.name IS NULL
e.dept.name IS NOT NULL
e.dept IS NOT NULL