建站软件免费版下载/成都网站关键词推广

涉及到表的处理请参看原表结构与数据  Oracle建表插数据等等

创建视图,把tb_Employee表sal<1000的雇员，映射到该视图( view)

create or replace view myview as
select * from tb_Employee where sal<1000 with read only constraint;

为了简化操作，用视图解决，显示雇员雇员号，姓名和部门名称

create view myview2 as
select tb_Employee.empno,tb_Employee.ename,tb_Department.dname from tb_Employee,dept where tb_Employee.deptno=tb_Employee.pk_Department_ID;

删除视图

drop view myview;