create view v_Error_turbines as select * from Error_turbines;create or replace trigger ErrorNotrg
instead of insert on v_Error_turbines
for each row
declare
i number:=1;
j number;
begin
select max(ErrorNo) into j from Error_turbines
where Error_turbines.TurbineID=:new.TurbineID;
i:=j+1;
insert into Error_turbines(ErrorNo)
values(i);
end;
/
由于触发表不能在触发体内触发,哪只有创建视图触发器,以后对视图v_Error_turbines插入工作,就可对Error_turbines相应更新
insert into v_Error_turbines values(...);
instead of insert on v_Error_turbines
for each row
declare
i number:=1;
j number;
begin
select max(ErrorNo) into j from Error_turbines
where Error_turbines.TurbineID=:new.TurbineID;
i:=j+1;
insert into Error_turbines(ErrorNo)
values(i);
end;
/
由于触发表不能在触发体内触发,哪只有创建视图触发器,以后对视图v_Error_turbines插入工作,就可对Error_turbines相应更新
insert into v_Error_turbines values(...);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货