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:

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.