Cursors in PL/SQL

Static cursors
Dynamic cursors
Cursors with parameters
for update
Ref cursors
explicit cursors.
ref cursor from record type.