Create CUSTOM cursor with query languages using a keyword DECLARE FETCH cursor with "All " key or indexes.
DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1 ; FETCH ALL from ALL_EMP DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1 ; FETCH 2 from ALL_EMP
DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1 ; FETCH ALL from ALL_EMP
DECLARE ALL_EMP CURSOR FOR SELECT * FROM table_pgsql1 ; FETCH 2 from ALL_EMP