Syntax That is Incompatible with the FOR UPDATE Clause

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > SELECT >

Syntax That is Incompatible with the FOR UPDATE Clause

A SELECT statement that uses a FOR UPDATE clause must conform to the following restrictions:

The statement can select data from only one table.
The statement cannot include any aggregate functions.
The statement cannot include any of the following clauses or keywords: DISTINCT, FOR READ ONLY, GROUP BY, INTO SCRATCH, INTO TEMP, INTO EXTERNAL, ORDER BY, UNION, or UNIQUE.

For information on how to declare an update cursor for a SELECT statement that does not include a FOR UPDATE clause, see Using the FOR UPDATE Option.

FOR READ ONLY Clause

Use the FOR READ ONLY keywords to specify that the select cursor declared for the SELECT statement is a read-only cursor. A read-only cursor is a cursor that cannot modify data. This section provides the following information about the FOR READ ONLY clause:

When you must use the FOR READ ONLY clause
Syntax restrictions on a SELECT statement that uses a FOR READ ONLY clause