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