Types of Cursor in SQL
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 are the cursors declared automatically by the Query Processing Software. Cursors are declared implicitly for all Data Manipulation Language (DML) statements.
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.