Advanced DBMS

A cursor is a temporary work area created in the system memory when a SQL statement is executed. It contains information on a select statement and the rows of data accessed by it.

The set of rows returned by a cursor is called an Active Data Set (Result Set).

The purpose of a cursor is to store the data retrieved from the database, and perform intermediate operations before displaying the output to the client.

<p>Cursors allow us to process data row-by-row, which can be useful when complex calculations or transformations on the data are needed.</p> Signup and view all the answers

<p>The Current Row inside the Active Data Set (Result Set) is identified by the cursor, which allows the individual processing of each row.</p> Signup and view all the answers