- 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博客 ” ,链接:http://blog.itpub.net/196700/viewspace-674917/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/196700/viewspace-674917/