----------------------对一张表增删改的触发-------------------------------------------

CREATE OR REPLACE

TRIGGER ZHJK AFTER INSERT OR UPDATE OR DELETE ON ITIL_USR_DEPARTMENT_DAG FOR EACH ROW BEGIN  case  when inserting then    insert into ) values(:new.id,:new.name,:new.alias,:new.p_name);   when updating then     update set ORG_NAME=:new.name,ALIAS=:new.alias,PARENT_ORG_NAME=:new.p_name where id=:new.id;     when deleting then     delete where id=:old.id;    end case; END;