不很明白你的意思,你是想在修改了 B 表以后修改 A 表吗?如果是,可以使用触发器实现
create or replace trigger mytrigger_1 after update on TBLICDCOSTITEMdt as
begin
update TBLICDCOSTITEM a set a.ici_code:=:new where a.ici_code:=:old;
end;
create or replace trigger mytrigger_1 after update on TBLICDCOSTITEMdt as
begin
update TBLICDCOSTITEM a set a.ici_code:=:new where a.ici_code:=:old;
end;
如果你要级联修改,只有用触发器实现。楼上说的十分明白。我已无话可说了
create or replace trigger mytrigger_1 after update on TBLICDCOSTITEMdt as
begin
update TBLICDCOSTITEM a set a.ici_code:=:new where a.ici_code:=:old;
end;