A predicate specifies a condition that is true or false about a given row or group. The following predicates are supported:
- Comparison predicates, such as =, <>,
<, <=, >=,
>, <>
- IN predicate
-
LIKE predicate
Note: Prefixed expressions perform better and should be used where possible.
- NULL predicate
- Quantified comparison predicate (= ANY)
- Quantified IN predicate (ANY .... IN (....))
- IN_FOLDER predicate function