|< < 47 > >|

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.

|< < 47 > >|