oracle-cursor.sql

--http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23plsql-1906474.html

DECLARE
     l_total       INTEGER := 10000;
     CURSOR employee_cur
     IS
          SELECT employee_id
            FROM plch_employees
        ORDER BY salary ASC;
     employee_rec   employee_cur%ROWTYPE;
BEGIN
     FOR employee_rec IN employee_cur
     LOOP
          folderid_map(template_cur_rec.folder_id):=template_cur_rec.new_folder_id;
     END LOOP;
     
END;