static cursor

A type of cursor in which neither the cursor owner nor any other user can change the result set while the cursor is open. Values, membership, and order remain fixed until the cursor is closed. You can either take a "snapshot" (temporary table) of the result set, or you can lock the entire result set to prevent updates. When you take a snapshot of the result set, the result set diverges increasingly from the snapshot as updates are made.