21 of 62
create or replace trigger v_customer_id
uinstead of delete on v_customer
begin
u delete from
address
where
cust_id=:old.cust_id;
u delete from
customer
where
cust_id=:old.cust_id;
uend;
INSTEAD-OF Delete