17,089
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure TT_PROC
AS
BEGIN
INSERT INTO T4(C1,C2,C3……) -- 数据有400W
SELECT C1,C2,C3 FROM T1,T2 WHERE ……;
commit;
end;
create or replace procedure TT_prc
as
declare
i number;
begin
i:=0;
loop
INSERT INTO T1(C1,C2,C3……)
SELECT C1,C2,C3……
FROM T2,T3 WHERE ……;
i := i+1;
if mod(i,2000)=0 then
commit;
end loop;
commit;
end;
create or replace procedure TT_prc
as
declare
i number;
begin
i:=0;
loop
INSERT INTO T1(C1,C2,C3……)
SELECT C1,C2,C3……
FROM T2,T3 WHERE ……;
i := i+1;
if mod(i,2000)=0 then
commit;
end loop;
commit;
end;