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

---

EJB query language
WHERE clause

Using EJB query
    

 

---