创建视图

create Or Replace view t as

select T1.t11 f1 ,T1.t12 f2 ,T2.t22 f3

from T1,T2

Where T1.t11=T2.t11;

视图更新Create Or Replace Trigger Trg_InsUpdDel_t

Instead Of Insert or update or delete

on t

for each row

Declare

begin

If Inserting Then

Insert Into t1 (t11,t12) Values (:New.f1,:New.f2);

Insert Into t2 (t11,t22) Values (:New.f1,:New.f3);

elsif Updating Then

Update t1 set t11=:New.f1,t12=:New.f2 where t11=:New.f1;

Update t2 set t11=:New.f1,t22=:New.f3 where t11=:New.f1;

elsif Deleting then

Delete from t1 where t11=:Old.f1;

Delete from t2 where t11=:Old.f1;

End if;

end;