摘要:
行级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... 阅读全文