| Info |
|---|
A cursor in SQL is a database object used to retrieve rows from a result set one at a time, instead of the whole set at once. It allows you to control and manage rows (records) from a database that has been output from a query, acting somewhat like a pointer to this data. |
Cursors are primarily used when you need to update records in a database table in a singleton manner or in a row by row manner, in other words, when you need to manipulate rows individually.
...