what is cursor in dbms
Cursor :
Cursor is a Temporary Memory or Temporary Work Station.
It is Allocated by Database Server at the Time of Performing
DML operations on Table by User. Cursors are used to store Database Tables.
There are 2 types of Cursors: Implicit Cursors, and Explicit Cursors.
These are explained as following below.
a) Implicit Cursors:
Implicit Cursors are also known as Default Cursors of SQL SERVER.
These Cursors are allocated by SQL SERVER when the user performs DML operations.
b) Explicit Cursors :
Explicit Cursors are Created by Users whenever the user requires them.
Explicit Cursors are used for Fetching data from Table in Row-By-Row Manner.