Types of Cursor in SQL
Cursor:
A cursor allows you to name these work areas and access their stored information. There are two types of cursors. These are:
i. Implicit Cursors
ii. Explicit Cursors
Implicit Cursors:
Implicit Cursors are the cursors declared automatically by the Query Processing Software. Cursors are declared implicitly for all Data Manipulation Language (DML) statements.
Explicit Cursors:
Explicit Cursors are user-defined cursors declared in EXEC…END-EXEC block. These cursors can be named and manipulated through other statements within the block. It allows multiple rows to be processed from the query result.