22 of 62
create or replace trigger v_customer_iu
instead of update on v_customer
begin
update customer set name_tx
= :new.name_tx
where cust_id = :old.cust_id;
if :old.addr_id is not null
and :new.street_tx is null then
delete from address
where addr_id=:old.addr_id;
elsif :old.addr_id is null
and :new.street_tx is not null then
insert into
address(…) values (…);
else
update address set…
where addr_id=:old.addr_id;
end if;
end;
INSTEAD-OF Update