Statement | Effect on Cursor Position |
OPEN | Cursor positioned before first row in set. |
FETCH | Cursor moves to next row in set. If it is already on the last row, the cursor moves beyond the set and its position becomes undefined. |
UPDATE(CURSOR) | Cursor remains on current row. |
DELETE(CURSOR) | Cursor moves to a position after the deleted row (but before the following row). |
CLOSE | Cursor and set of rows become undefined. |