BEGIN WORK; -- Set up a cursor: DECLARE liahona SCROLL CURSOR FOR SELECT * FROM film; -- Fetch the first 5 rows in the cursor liahona: FETCH FORWARD 5 FROM liahona; -- Fetch the previous row: FETCH PRIOR FROM liahona; -- Close the cursor and end the transaction: CLOSE liahona; COMMIT WORK;
