Positioned updates/deletes Describes row modification based on a FOR UPDATE cursor. Understanding positioned update or delete This is an introduction to SQL positionned UPDATE/DELETE. DECLARE (SELECT ... FOR UPDATE) Associate a database cursor with a SELECT statement to perform positioned updates and deletes UPDATE ... WHERE CURRENT OF Updates the current row in a result set of a database cursor declared for update. DELETE ... WHERE CURRENT OF Deletes the current row in a result set of a database cursor declared for update. Examples WHERE CURRENT OF usage examples.