EJB Query 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

---

Related concepts

EJB query language
WHERE clause

 

Related tasks

Use EJB query