Cursors allow a client application to access individual rows within a result set, rather than merely retrieve a complete set of data rows.
A single connection can have multiple cursors open at the same time. All of the cursor result sets are simultaneously available to the application, which can fetch data rows from them at will. This is in contrast to other types of result sets, which must be handled one row at a time in a sequential fashion.
Further, a client application can update underlying database tables while actively fetching rows in a cursor result set.
