Cursors in PL/SQL

Static cursors

Dynamic cursors

Cursors with parameters

for update

Ref cursors

explicit cursors.

ref cursor from record type.

The where current of clause can be used to update or delete the record that the cursor actually points to. See this example for a demonstration.

cursor concept.