NULL predicate

The NULL predicate tests for null values

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

 

See Also

EJB query language
WHERE clause
Using EJB query