create or replace trigger DeleteTable_on
after Delete on a
for each row
begin
update b set id=:new.id+1 where id=new.id;
end DeleteTable_on;
after Delete on a
for each row
begin
update b set id=:new.id+1 where id=new.id;
end DeleteTable_on;
after delete on A
for each now
begin
b.id=b.id+1;
exception
...
end;
after delete on A
for each now
begin
update b set id=:new.id+1 where id=new.id;
exception
...
end;
before delete on a
for each row
begin
update b set id=id+1 where id=:old.id;
end;
/
忘了告诉各位老大了.
好像new old 等关键字只能用在insert,update等.不能用在delete上