Cursor and Its Types

Question

Hi!!

I am new to the Database. Can someone tell me what is a cursor and what are its various types?

Answer 1

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.