数据库-视图
为什么? 权限控制(with read only)、数据同步(视图中数据进行更改,基表也会同步变更)
怎么理解?存储起来的select语句
怎么创建?create view empview as select employee_id,last_name,slary from employees where department_id = 80
简单视图、复杂视图? 是否使用组函数 create or replace view empview as select department_name,avg(salary) avg_sal
from employees e,departments d where e.department_id = d.department_id group by department_name
复杂视图不支持修改操作