Retrieving specific data with conditions is called a search. A search condition is specified to manipulate data in a table on the basis of a condition. A search condition selects the rows to be manipulated; multiple conditions can be combined using logical operators. The following four methods are provided for searching for data in a table:

• Searching for data within a specified range of values
• Searching for a specified character pattern
• Searching for non-NULL data
• Searching for data that satisfies multiple conditions

Organization of this section

2.7.1 Searching for data within a specified range of values

2.7.2 Searching for a specific character pattern

2.7.3 Searching for non-NULL data

2.7.4 Searching for data that satisfies multiple conditions

2.7.5 Searching for data using a Boolean predicate

2.7.6 Searching for data using a structured repetition predicate

2.7.7 Searching for data using a subquery