Three broad categories identify cursors according to their sensitivity to change:
Static – values, order, and membership in the result set do not change while the cursor is open.
Keyset-driven – values can change, but order and membership in the result set remain fixed at open time (the moment the cursor is opened).
Dynamic – values, order, and membership in the result set can all change.
