Notice: Undefined index: HTTP_ACCEPT_ENCODING in C:\server\web\www.showyounger.com\s-system.php on line 2
编写触发器实现两张表数据同步 | 小样儿(ShowYounger)
小样儿,顶呱呱!!![http://www.showyounger.com]
- 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;