19 of 62
create or replace view v_customer
as
uselect c.cust_id,
c.name_tx,
a.addr_id,
u a.street_tx,
a.state_cd,
a.postal_cd
from customer c
uleft outer join address a
on c.cust_id =
a.cust_id
De-Normalized view
