A program that retrieves and processes each row returned by the SQL statement individually is referred to as a cursor. Two categories of cursors exist Implicit Cursors and Explicit Cursors.

Types of Cursor:

Explicit Cursor. An explicit cursor requires a declaration by the user by the use of the SELECT statement. It goes over each record but only a single row is processed at a time.

Implicit Cursor. An implicit cursor is put internally by SQL whenever the user runs any DML query.