Cursors are associated with a select statements, and.consist of:
Cursor result set – the set (table) of qualifying rows that results from the execution of a query associated with the cursor.
Cursor position – a pointer to a row within the cursor result set If a cursor is not specified as read-only, you can explicitly modify or delete that row using update or delete statements.
Two attributes specify the cursor’s behavior:
Sensitivity
Scrollability
There are four types of cursors:
Client cursors
Execute cursors
Server cursors
Language cursors
