Requirements for Updatable Result Sets

Only specific SELECT statements- simple accesses of a single table-allow you to update or delete rows as you step through them.

To create an updatable result set, you must use a JDBC peer client connection to execute a query that specifies the FOR UPDATE clause. For more information, see SELECT and FOR UPDATE Clause.

See also SQL Language Limitations for information about limitations with updatable results.