摘要: 级联修改触发器create trigger mutli_tgr after update of goodsid on goodsfor each rowbegin update sa set goodsid = :new.goodsid where goodsid = :old.goodsid; dbms_output.put_line('数据已经级联修改……');end;语句级触发器create trigger stat_tgr before delete on goods2begin if to_char(sysdate,'dd')='20' 阅读全文
posted @ 2012-04-20 22:14 shuaisam 阅读(168) 评论(0) 推荐(0) 编辑