参考下: create or replace trigger tgname after update of prod_ID on A for each row beginif :new.prod_ID=1 then update b set ...where b.prod_ID=1; else insert into b values(...); end if; end;
if updating('prod_ID') then insert into b values(...); end ifif updating and :new.prod_ID==变量1 then update b set ...where b.prod_ID=变量1; end if变量1 保存了你所说的1
create or replace trigger tgname
after update of prod_ID on A
for each row
beginif :new.prod_ID=1 then
update b set ...where b.prod_ID=1;
else
insert into b values(...);
end if;
end;
insert into b values(...);
end ifif updating and :new.prod_ID==变量1 then
update b set ...where b.prod_ID=变量1;
end if变量1 保存了你所说的1