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

 

Related Tasks

Using EJB query

 

---