Previous Topic: Predicates and Search ConditionNext Topic: Expansion of Between-predicate


Overview

This chapter presents expanded syntax for each predicate that can be used in a search condition. It concludes with expanded syntax for search-condition.

What is a Predicate?

A predicate is an operand of a search condition. It expresses or implies a comparison operation.

What is a Search Condition?

A search condition is a Boolean expression that yields a truth value. The operands of a search condition are predicates, and the operators are the logical operators AND, OR, and NOT.

A search condition establishes a criterion for selecting rows from a table.