增删改触发器语句

来源:互联网 发布:虚拟机怎么设置网络 编辑:程序博客网 时间:2024/05/29 14:00
create or replace trigger TR_EVENT_RELEASE  after insert or update or delete  on event  for each rowdeclare  -- local variables herebegin  if inserting then    insert into event_release(event_num, release_status) values(:new.event_num, 0);   elsif updating then     update event_release set event_num = :new.event_num;   elsif deleting then      delete event_release where event_num = :new.event_num;   end if;end TR_EVENT_RELEASE;