A program that retrieves and processes each row returned by the SQL statement individually is referred to as a cursor. Two categories of cursors exist Implicit Cursors and Explicit Cursors.
Types of Cursor:
Explicit Cursor. An explicit cursor requires a declaration by the user by the use of the SELECT statement. It goes over each record but only a single row is processed at a time.
Implicit Cursor. An implicit cursor is put internally by SQL whenever the user runs any DML query.
A cursor is a mechanism used to iterate over the elements of a collection, such as a database result set or a data structure. It allows you to access and manipulate individual elements one at a time. Cursors are commonly used in database management systems and graphical user interfaces. There are several types of cursors available, depending on the specific programming language or database system being used. Here are some common types of cursors:
Forward-only Cursor
Scrollable Cursor
Static Cursor
Dynamic Cursor
Keyset-driven Cursor
Read-only Cursor
These are some of the commonly used cursor types. The availability and specific characteristics of cursor types may vary depending on the programming language, database system, or framework you are working with.
A program that retrieves and processes each row returned by the SQL statement individually is referred to as a cursor. Two categories of cursors exist Implicit Cursors and Explicit Cursors.
Types of Cursor:
Explicit Cursor. An explicit cursor requires a declaration by the user by the use of the SELECT statement. It goes over each record but only a single row is processed at a time.
Implicit Cursor. An implicit cursor is put internally by SQL whenever the user runs any DML query.