Objective :
  • Create CUSTOM cursor  with query languages using a keyword DECLARE
  • FETCH cursor with "All " key or indexes.
 
Script:

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