NULL predicate

 

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



Related concepts
EJB query language
WHERE clause

Related tasks
Using EJB query