What is cursor in sql?

Cursor is a database object used by applications to manipulate data in a set on a row-by- row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. In order to work with a cursor we need to perform some steps in the following order:

1. Declare cursor


2. Open cursor


3. Fetch row from the cursor


4. Process fetched row


5. Close cursor


6. Deallocate cursor