20 of 62
create or replace trigger v_customer_ii
instead of insert on v_customer
declare
v_cust_id
customer.cust_id%rowtype;
begin
if :new.name_tx is not null then
insert into customer (cust_id,name_tx)
values(object_seq.nextval, :new.name_tx)
returning cust_id into
v_cust_id;
if :new.street_tx is not null then
insert into address (addr_id,street_tx,
state_cd,
postal_cd, cust_id)
values
(object_seq.nextval,:new.street_tx,
:new.state_cd,:new.postal_cd, v_cust_id);
end if;
end;
INSTEAD-OF Insert