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.