A database Cursor is a control which enables traversal/ iteration over the rows or records in the table.
5 step process:
- Declare
- Open
- Fetch using while loop
- Close
- Deallocate
LIMITATION
A cursor is a MEMORY resident set of pointers. Meaning it occupies lots of memory from your system which is not good for performance.
Tags:
SQL Advance