56 of 62
FORALL Example
declare
type number_nt is
table of NUMBER;
v_deptNo_nt
number_nt:=number_nt(10,20);
begin
forall i in v_deptNo_nt.first() ..v_deptNo_nt.last()
update emp
set sal=sal+10
where deptNo=v_deptNo_nt(i);
end;