create or replace trigger afupdate
after update on contact
referencing new as new old as old
for each row
declare
v_registerday_old table2.registerdayold%type; --记录修改前的内容;
v_times table2.times%type; --记录修改次数的变量
v_count number;
begin
begin
select max(times) into v_times form table2 where instr(id,:old.id)>0;
v_times:=v_times+1;
exception
when others then
v_times:=1;
end;if :new.registerday<>:old.registerday then
v_registerdayold:=null;
else
v_registerdayold:=:old.registerday; --记录修改前的值;
end if;
insert into table2(id,name,registerdayold,times)
values(:new.id,:new.name,v_registerdyaold,v_times);
end afupdate;
after update on contact
referencing new as new old as old
for each row
declare
v_registerday_old table2.registerdayold%type; --记录修改前的内容;
v_times table2.times%type; --记录修改次数的变量
v_count number;
begin
begin
select max(times) into v_times form table2 where instr(id,:old.id)>0;
v_times:=v_times+1;
exception
when others then
v_times:=1;
end;if :new.registerday<>:old.registerday then
v_registerdayold:=null;
else
v_registerdayold:=:old.registerday; --记录修改前的值;
end if;
insert into table2(id,name,registerdayold,times)
values(:new.id,:new.name,v_registerdyaold,v_times);
end afupdate;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货