declare v_number NUMBER; v_number2 NUMBER;beginexecute immediate 'truncate table t2';insert into t2 select count(*) from dual;commit;begininsert into t2 select count(*) from t1;commit;end;end;
本文共 253 字,大约阅读时间需要 1 分钟。
declare v_number NUMBER; v_number2 NUMBER;beginexecute immediate 'truncate table t2';insert into t2 select count(*) from dual;commit;begininsert into t2 select count(*) from t1;commit;end;end;
转载于:https://www.cnblogs.com/zhaoyangjian724/p/3798029.html