pl/sql 在一个程序块里打印日志输出到表格

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;

posted @ 2014-03-12 21:39  czcb  阅读(280)  评论(0编辑  收藏  举报