create or replace trigger trig_table after delete on table_test for each rowdeclarebegin insert into table_rizhi(ID,YXJLS,BZ) values(自增序列,删除的记录数,'删除');end trig_nationry;
table_rizhi是日志表,如何才能获取在删除table_test表数据的同时,触发器实现插入日志表受影响的行数呢?
急用,请高手指点,谢谢!