SQL & PL/SQL

hello
please guide me

in SqlServer we can declare scroll cursor that we can fetch next record or preceding record
for example
---------------------------------------------------------------------------------
DECLARE authors_cursor SCROLL CURSOR FOR
SELECT au_lname, au_fname FROM authors
ORDER BY au_lname, au_fname

OPEN authors_cursor

-- Fetch the last row in the cursor.
FETCH LAST FROM authors_cursor

-- Fetch the row immediately prior to the current row in the cursor.
FETCH PRIOR FROM authors_cursor

-- Fetch the second row in the cursor.
FETCH ABSOLUTE 2 FROM authors_cursor
-----------------------------------------------------------------------------------
my question is that how i can do that in oracle ?
thanks