摘要: 行级DML触发器的创建create or replace trigger tri_goods after insert or update or deleteon goodsfor each rowbegin if inserting then insert into g_modify (oper_type,oper_time,goodsid,goodsname,remark,g_modify_id) values('添加的数据',sysdate,:new.goodsid,:new.goodsname,:new.remark,g_modify_id... 阅读全文
posted @ 2012-04-19 22:59 shuaisam 阅读(163) 评论(0) 推荐(0) 编辑