视图
create or replace view emp_v_deptno20 as select * from emp where deptno=20;
select * from emp_v_deptno20;
创建一个视图,通过该视图可以查询到工资在2000-5000内并且姓名中包含有A的员工编号,姓名,工资。
create or replace view emp_v_sal_ename as select empno,ename,sal from emp where (sal between 2000 and 5000) and 0<instr(ename,'A')
select ename from emp_v_sal_ename;
create or replace view emp_v_sal_ename as select empno 编号,ename 姓名,sal 工资 from emp where (sal between 2000 and 5000) and 0<instr(ename,'A')
select * from emp_v_sal_ename where 2000<工资;
create or replace view emp_V_FZ as select dname ,min(sal) minsal,max(sal) maxsal,avg(sal) avgsal
from emp e,dept d where e.deptno=d.deptno group by dname
select * from emp_V_FZ;
create or replace view emp_v_deptno as select * from emp where deptno=20;
insert into emp_v_deptno(empno,ename,job) values(7777,'雷杰','洗脚');
insert into emp_v_deptno(empno,ename,job,comm) values(8888,'雷杰1','洗脚1',9000);
insert into emp_v_deptno(empno,ename,job,comm) values(9999,'雷杰2','洗脚3',null);
insert into emp_V_FZ(dname,minsal,maxsal) values('雷杰',5475,100);
select* from emp_v_deptno;
update emp_v_deptno set job='洗头' where deptno=20
update emp_V_FZ set minsal=20;
create or replace view emp_v_dept as select empno,ename,dname from emp e,dept d where e.deptno=d.deptno;
update emp_v_dept set ename='zhangsan' where empno=7369;
create or replace view emp_v_deptno as select * from emp where deptno=20;
update emp_v_deptno set deptno=10 where empno=7369
create or replace view emp_v_deptno as select * from emp where deptno=20 with check option;
update emp_v_deptno set deptno=10 where empno=7566
select * from emp_v_dept
select* from emp_v_deptno;
select * from emp;