- create or replace trigger buid_mend_manager
- after insert or update or delete
- on TMP_EIC_MEND
- referencing old as old_value
- new as new_value
- for each row
- begin
- if inserting then
- insert into Eic_mend(mendid, mendname)
- values(:new_value.mendid, :new_value.mendname);
- elsif updating then
- update Eic_mend set mendname = :new_value.mendname
- where mendid = :new_value.mendid;
- elsif deleting then
- delete from Eic_mend where mendid = :old_value.mendid;
- end if;
- end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/196700/viewspace-674917/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
测试安装是否成功
请登录后发表评论
登录
全部评论
