Function
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only repositions the cursor and does not return rows.
Precautions
None
Syntax
1 | MOVE [ direction [ FROM | IN ] ] cursor_name; |
The direction clause specifies optional parameters.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | NEXT | PRIOR | FIRST | LAST | ABSOLUTE count | RELATIVE count | count | ALL | FORWARD | FORWARD count | FORWARD ALL | BACKWARD | BACKWARD count | BACKWARD ALL |
Parameter Description
MOVE command parameters are the same as FETCH command parameters. For details, see Parameter Description in FETCH.
On successful completion, a MOVE command returns a command tag of the form MOVE count. The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
Examples
Skip the first three rows of cursor1.
1 | MOVE FORWARD 3 FROM cursor1; |