Updatable cursors

Cursors are read-only by default. For a cursor to be updatable, you must specify SELECT . . . FOR UPDATE. Use FOR UPDATE only when you will be modifying rows to avoid excessive locking of tables.

Related concepts
ResultSets and auto-commit
Scrolling insensitive ResultSets
Related reference
Simple non-updatable ResultSets
Holdable cursors