关于Struts2 + spring + hibernate进Q群: 130529143交流。
有偿技术支持Q群:398162181
--创建视图
create or replace view empview2
as
select employee_id id, last_name name, salary, department_name
from employees e, departments d
where e.department_id = d.department_id
--允许只读操作
with read only
--复杂视图,一般不可进行增、删、改
create or replace view empview3
as
select d.department_name, avg(salary) "平均工资"
from employees e, departments d
where e.department_id = d.department_id
group by d.department_name;
--删除视图
drop view empview3 ;
--修改视图,类似修改表