create or replace trigger Tri_表A_上数据 after insert or update on 表A for each row declare intCount number(1); begin select count(*) into intCount from 表A where 列1 between 上限 and 下限; if intCount=1 then UPDATE 表A SET 列1=:new.列1, 列2=:new.列2, ............. WHERE where 列1 between 上限 and 下限; else INSERT INTO 表A values ( new.列1, new.列2, ....... ); end if; end Tri_表A_上数据;
after insert or update on 表A
for each row
declare
intCount number(1);
begin
select count(*) into intCount from 表A where 列1 between 上限 and 下限; if intCount=1 then
UPDATE 表A
SET 列1=:new.列1,
列2=:new.列2,
.............
WHERE where 列1 between 上限 and 下限;
else
INSERT INTO 表A values
( new.列1,
new.列2,
.......
);
end if;
end Tri_表A_上数据;