Update via cursor

A table can be updated via a cursor if the cursor description is updatable, i.e. the underlying query expression is updatable and no ORDER BY clause is specified. In addition, no SCROLL clause or FOR READ ONLY clause can be specified in the cursor declaration.

Use DELETE...WHERE CURRENT OF to delete rows in the updatable table via the cursor.

Use UPDATE...WHERE CURRENT OF to update rows in the updatable table via the cursor.