关注。刚才我试了半天,但是删除的行的数据总得不到!
create or replace trigger t_a
before delete on a
for each row
begin
insert into b values(:new.cola);
end t_a;
/插入是可以的:
create or replace trigger t_a
after insert on a
for each row
begin
insert into b values(:new.cola);
end t_a;
/
create or replace trigger t_a
before delete on a
for each row
begin
insert into b values(:new.cola);
end t_a;
/插入是可以的:
create or replace trigger t_a
after insert on a
for each row
begin
insert into b values(:new.cola);
end t_a;
/
应该用:old而不是:new!