Specifying Conditions in the WHERE Clause

These statements can include a WHERE clause to specify rows to operate on:

• For the DELETE statement, the WHERE clause specifies rows to delete.
• For the INSERT statement with an embedded SELECT, the WHERE clause specifies which rows to insert from another table.
• For the UPDATE statement, the WHERE clause specifies which rows to update. In addition, the SET clause can include an embedded SELECT statement whose WHERE clause identifies a row whose values are to be assigned to another row.
• For the UNLOAD statement, the WHERE clause of the embedded SELECT specifies which rows to unload.

The choice of a locale affects these uses of a WHERE clause in the same way that it affects the WHERE clause of a SELECT. For more information, see Logical Predicates in a WHERE Clause and Comparisons with MATCHES and LIKE Conditions.