create or replace procedure myproc as
x number(4);
begin
loop
insert into newtable values( . . . );
x := x+1;
if mod(x,2000) = 0 then
___commit;
end if;
exit when . . .
end loop;
end;
/
|
Results 1 to 7 of 7
Threaded View
|
Click Here to Expand Forum to Full Width |