trigger.sql

来自「linux下c 编写的 某项目代理服务端部分的代码。其中包括网络通信」· SQL 代码 · 共 33 行

create or replace trigger tri_alarm_upd_row_ins
after update of alarm_time  on ALARM
for each row
begin 
  insert into alarm_env(id_no,city_no,agency_no,
	alarm_site_no,alarm_csn,
	alarm_level_no,alarm_status_no,alarm_name_no,
	alarm_time,cancel_time,in_time,up_time,
	other,other1,remark)
  values(alarm_id_no.nextval,:new.city_no,:new.agency_no,
	:new.alarm_site_no,:new.alarm_csn,
	:new.alarm_level_no,:new.alarm_status_no,:new.alarm_name_no,
	:new.alarm_time,null,:new.in_time,:new.up_time,
	:new.other,:new.other1,:new.remark);
end;
/

create or replace trigger tri_alarm_upd_row_upd
after update of cancel_time on ALARM
for each row
begin 
  update alarm_env set 
	alarm_status_no=:new.alarm_status_no,
	cancel_time=:new.cancel_time,
	up_time=:new.up_time
  where alarm_site_no=:new.alarm_site_no
	and alarm_name_no=:new.alarm_name_no
	and alarm_time<=:new.alarm_time
	and alarm_status_no='1' ;
end ;
/