可以
create or replace trigger hytest.hy_trg
before insert or update on hytest.hytest2
for each row
begin
update hytest.hytest
set "HYTEST"."HYTEST"."NAME"='TT';
end;
create or replace trigger hytest.hy_trg
before insert or update on hytest.hytest2
for each row
begin
update hytest.hytest
set "HYTEST"."HYTEST"."NAME"='TT';
end;
create or replace trigger trigerAB
after insert on A
for each row
begin
update b set status=1 where b.id=a.id
end;
但是我感觉这样好像不对啊。尤其是update b set status=1 where b.id=a.id
这一句不是修改b中某一项的status吧?这里是否应该修改for each row?
我这里需要的是仅仅修改b中与A的bid相同的那个项的status。具体应该怎么写?请指点一下,谢谢了