create or replace trigger TR_EVENT_RELEASE
after insert or update or delete
on event
for each row
declare
-- local variables here
begin
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;
增删改触发器语句
最新推荐文章于 2024-05-06 10:15:24 发布