CURSOR_FORWARD_BACKWARD1
 
DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1; FETCH ALL from ALL_EMP

Script:

 DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1; FETCH FORWARD 4 ALL_EMP

DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1; FETCH BACKWARD -2 IN ALL_EMP