The cursor is a temporary work area which stores the data as well as the result set occurred after manipulation of data retrieved.
A cursor can hold only one row at a time.
The types of Cursor are:
Implicit cursors: These types of cursors are declared automatically when DML statements like INSERT, UPDATE, DELETE are executed.
Explicit cursors: These types of cursors have to be declared when SELECT statements which are returning more than one row are executed.