+

Search Tips   |   Advanced Search

 

WHERE clause

 

The WHERE clause lists search conditions for items to add to a result set. The WHERE clause contains search conditions composed of the following:

If the search condition evaluates to TRUE, the tuple is added to the result set.


Sub-topics


Literals

Input parameters

Expressions

Basic predicates

Quantified predicates

BETWEEN predicate

IN predicate

LIKE predicate

NULL predicate

EMPTY collection predicate

MEMBER OF predicate

EXISTS predicate

IS OF TYPE predicate

 

Related concepts


EJB query language

 

Related tasks


Use EJB query