A cursor is used to access the result set stored in the memory on execution of a query. It is a special programming construct that allows data to be manipulated on a row-by-row basis. They point to a certain location within a record set and allow the operator to move forward (and sometimes backward, depending upon the cursor type) through the results one record at a time.
Asensitive – If the property is asensitive, the server may or may not make of the result table. This indicates that the data retrieved by this cursor is independent of any updates from other cursors.
Read only - These cursors cannot be updated.
Non-scrollable - These cursors can only be traversed in one direction and cannot skip rows.
