7.19 Predicates

The following lists the predicates that can be used. This section describes the functions and specification formats of these predicates.

• BETWEEN predicate

• EXISTS predicate

• IN predicate

• LIKE predicate

• LIKE_REGEX predicate

• NULL predicate

• Comparison predicate

• Quantified predicate

These predicates can be specified in search conditions.

Organization of this section

• 7.19.1 BETWEEN predicate

• 7.19.2 EXISTS predicate

• 7.19.3 IN predicate

• 7.19.4 LIKE predicate

• 7.19.5 LIKE_REGEX predicate

• 7.19.6 NULL predicate

• 7.19.7 Comparison predicate

• 7.19.8 Quantified predicate

To Page Top