Trigger to update table A after update or delete on table B:
create or replace trigger test
after insert or update on b
for each row
begin
update a
set a.column1=:new.column1
, a.column2=:new.column2
where a.idno=:new.idno;
end;
|
Results 1 to 4 of 4
Thread: pl/sql triggerHybrid View
|
Click Here to Expand Forum to Full Width |