- VIEW 는 데이터를 물리적으로 저장하지 않고, SQL 을 저장함.
- 자주 사용하는 SQL 을 매번 작성해 실행하기 귀찮으니 VIEW 로 만들어 사용함.
select first_name, last_name, address
from customer join address
on customer.address_id = address.address_id
-- view 생성
create view customer_info as
select first_name, last_name, address
from customer join address
on customer.address_id = address.address_id
-- view 조회
select * from customer_info
-- view 수정
create or replace view customer_info as
select first_name, last_name, address, district
from customer join address
on customer.address_id = address.address_id
-- view 이름 변경
alter view customer_info rename to c_info
-- view 삭제
drop view c_info