视图（view）用法

--创建视图()
--例A
create view zhonghq_dept_v as
select id,dept_code,dept_name from zhonghq_dept;

select * from zhonghq_dept_v;

--例B (可以从另外一视图或者表创建新的视图)
create view zhonghq_user_dept_v as
select * from zhonghq_dept_v;

select * from zhonghq_user_dept_v;

--更新视图（以前的视图会被覆盖掉）
create or replace view zhonghq_dept_v as
select id from zhonghq_dept;

create or replace view zhonghq_dept_v as
select id,remark from zhonghq_dept;

--撤销视图
drop view zhonghq_dept_v;