6.1.11. FOR UPDATE [OF]

Syntax

  1. SELECT ... FROM single_table
  2.   [WHERE ...]
  3.   [FOR UPDATE [OF ...]]

FOR UPDATE does not do what it suggests. Its only effect currently is to disable the pre-fetch buffer.

It is likely to change in future: the plan is to validate cursors marked with FOR UPDATE if they are truly updateable and reject positioned updates and deletes for cursors evaluated as non-updateable.

The OF sub-clause does not do anything at all.