Using the Relational Data Framework › Searched Operations › Clauses Used in Searched Operations

Clauses Used in Searched Operations

When performing search operations, you can use the following clauses:

• WHERE clause

  This is the most commonly used clause in searched operations. The WHERE clause allows you to specify the conditions that determine which data is to be retrieved and optionally updated or deleted. The WHERE clause is also used in cursor operations to search for data.

• ORDER BY clause

  This clause may be used in searched operations. The ORDER BY clause allows you to specify the order in which values are returned from tables.