什么是视图呢?视图是一种虚表,是建立在已有表的基础上,
也可以称视图为存储起来的select语句。
创建视图:
--在 create view语句中嵌入子查询
create view empview
as S
select employee_id,last_name,department_name
from employees e,departments d
Where e.department_id = d.department_id
--查询视图
select * from empview
创建/更新视图:
--create or replace
create or replace view empview
as
select employee_id,last_name,department_name,salary
from employees e,departments d
Where e.department_id = d.department_id
--查询更新后的视图
select * from empview
创建复杂视图:
create view dept_sum_vu(name, minsal, maxsal, avgsal)
as select d.department_n