what is the difference between Static cursor,Dynamic cursor and keyset cursor

Hi shortly:

• STATIC cursor: in the background creates a temporary table and fills it with the resultset of the select of the cursor. Then it fetches these static state of records from that temp table independently the original source of data.


• DYNAMIC cursor: in every row fetch executes the base query again and again but returns only the corresponding row from the resultset


• KEYSET cursor: stores only the primary keys in the backgound temporary table and in every row-fetch it queries the original data based on the current key

---

m@te