bulk collect and forall in oracle example
DECLARE
CURSOR c1 IS
SELECT ENAME FROM emp;
TYPE lv_emp_name_tbl IS TABLE OF VARCHAR2(50);
lv_emp_name lv_emp_name_tbl;
BEGIN
OPEN c1;
FETCH c1 BULK COLLECT
INTO lv_emp_name LIMIT 5000;
FOR c_emp_name IN lv_emp_name.FIRST .. lv_emp_name.LAST LOOP
Dbms_output.put_line('Employee Fetched:' || c_emp_name);
END LOOP;
FORALL i IN lv_emp_name.FIRST .. lv_emp_name.LAST
UPDATE emp SET sal = sal WHERE ename = lv_emp_name(i);
COMMIT;
Dbms_output.put_line('Salary Updated');
CLOSE c1;
END;
select * from emp;
