没有测试,你看看对部队 CREATE OR REPLACE TRIGGER tri_abc AFTER DELETE ON TB1 FOR EACH ROW DECLARE n_tid VARCHAR2(20); BEGIN o_id :=:OLD.id; update TB1 set id=id - 1 where id > o_id; END tri_abc;
create or replace trigger test after delete on system.t3 for each row declare begin update system.t3 set t3.id = t3.id - 1 where t3.id > :old.id; end test; 测试过,可行
CREATE OR REPLACE TRIGGER tri_abc
AFTER DELETE
ON TB1
FOR EACH ROW
DECLARE
n_tid VARCHAR2(20);
BEGIN
o_id :=:OLD.id;
update TB1 set id=id - 1 where id > o_id;
END tri_abc;
after delete on system.t3
for each row
declare
begin
update system.t3 set t3.id = t3.id - 1 where t3.id > :old.id;
end test;
测试过,可行