DML(insert,update,delete) ,DML触发器的触发事件有INSERT、UPDATE和DELETE三种,DML触发器是定义在表上的触发器;
DDL(create,alter,drop),
instead of 触发器(作用于复杂视图),
系统触发器
--行触发器,
create or replace
trigger test_delete before delete on test for each row
begin
Dbms_Output.Put_Line(:old.test_a);
delete insert_test where test_a=:old.test_a;
end;
注意:行触发器中将for each row 去掉,则成语句触发器,即只执行一次
--创建同义词
CREATE OR REPLACE SYNONYM "DRM_PFM"."C_ERPORGANISATION" FOR "CSG_MDM"."C_ERPORGANISATION";