Cursors
A cursor provides row-level access to query results.
- Designed for "lazy" access.
- Don't evaluate the entire query before providing access to the
first row.
- That would require putting all the result rows somewhere.
- It delays the application from proceeding.
- The entire result might not be consumed anyway.
- for loop is implemented on top of cursors.
|