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;
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;