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;