declare v_number NUMBER;
v_number2 NUMBER;
begin
execute immediate 'truncate table t2';
insert into t2 select count(*) from dual;
commit;
begin
insert into t2 select count(*) from t1;
commit;
end;
end;
转载于:https://www.cnblogs.com/zhaoyangjian724/p/3798029.html