A cursor is a type of temporary memory or workstation. It is allocated by the database server when the user performs DML (Data Manipulation Language) actions on a table. Database Tables are stored in cursors. Cursors are classified into two types: implicit and explicit. These are detailed further below.

1.Implicit Cursors:

Implicit Cursors are also known as SQL SERVER Default Cursors. When the user conducts DML activities, SQL SERVER allocates these Cursors.

2.Explicit Cursors:

Explicit Cursors are created by users whenever they are needed. For fetching data from a table in a row-by-row fashion, explicit cursors are utilised.