?????????????View????
??????1?????????????
??????2??????????????斜???????? ??????????????些????????
??????3?????????????????????? SELECT ????????????????娲�?????? SELECT ???
??????4????????????????????????????????
??????5???????写娲�????????????????????????娲�???????
??????6????????????????????????????????????????????
??????7??????????????0?????????
????????????????????
??????1??????????????????????????????');" target="_self">?????????????????????????些??????????????????????
??????2?????????????SQL????????写????????????????????????效??
??????????????
??????1?????校????????????????渭??????????????????????????
?????????????
??????1?????????????
??????2??????????
??????3???????????????
??????4?????????????????胁??????????
????????emp???????校????????emp_view_1??create view ????? as select???????????????
????create view emp_view_1
????as
????select * from emp;
???????????锟�???????????????????????sysdba??????creare view?????
??????sysdba???????scott???create view???
????grant create view to scott;
??????sysdba????????scott???create view???
????revoke create view from scott;
????????emp??????校????????emp_view_2??????????????/????/????/??薪/???????????????斜?????
????create view emp_view_2
????as
????select empno "???"??ename "????"??sal "????"??sal*12 "??薪"??sal*12+NVL(comm??0) "??????"
????from emp;
????????emp??????校????????emp_view_3(a??b??c??d??e)?????????/????/????/??薪/????????????????????
????create view emp_view_3(a??b??c??d??e)
????as
????select empno "???"??ename "????"??sal "????"??sal*12 "??薪"??sal*12+NVL(comm??0) "??????"
????from emp;
???????emp_view_3??????????
????desc emp_view_3;
???????emp_view_3(id??name??salary??annual??income)?????create or replace view ????? as ????
????create or replace view emp_view_3(id??name??salary??annual??income)
????as
????select empno "???"??ename "????"??sal "????"??sal*12 "??薪"??sal*12+NVL(comm??0) "??????"
????from emp;
???????emp???????????????????????????????
????select min(sal)??max(sal)??round(avg(sal)??0)??deptno
????from emp
????group by deptno;
???????????emp_view_4??????邪????????????????????????????
????create or replace view emp_view_4
????as
????select deptno "?????"??min(sal) "?????"??max(sal) "?????"??round(avg(sal)??0) "???????"
????from emp
????group by deptno;
???????????emp_view_5??????邪???????????????????????????????????
????create or replace view emp_view_5
????as
????select e.empno "???"??e.ename "????"??e.sal "????"??d.dname "??????"??s.grade "??????"
????from emp e??dept d??salgrade s
????where (e.deptno=d.deptno) and (e.sal between s.losal and s.hisal);
??????????emp_view_1?械?7788??????????????delete????????????????
????delete from emp_view_1 where empno=7788;写???????????????
???????emp_view_1?????????with read only?????????????delete????????????
????create or replace view emp_view_1
????as
????select * from emp
????with read only;
???????????delete??????
???????????械????????????????????
????????????
??????????????????????????????
??????????????
???????????????????????
???????????????
????????????????????
????????????
??????????????????????
??????????????????????
????????
??????????????Index??
??????1????????????????????????????????????????
??????2??????????????/些?????????娲�?????????????
??????????????
??????1???????????Oracle?????????????
??????2?????rowid?????位?????????????????I/O
????rowid??oracle????????????????????
????rowid?????
??????1??位????????校???????????????????纾篸esc emp?????????
??????2???????select?校????写??rowid?????????
??????3???????????????????????????rowid?????????rownum???????????rowid???????
??????4??rowid??18位??小写??????????澹�????????????DBF????械?位??
??????5??rowid???????=/like????????''???????rowid??????????????????小写
??????6??rowid?????????DBF?????????
?????????????
??????1??????????????? Oracle?????????????????????? ??????Oracle????????????????????
??????2???????????????????????????????
??????3???????primary key??unique????????????????????????????
??????4?????????????????????????????位?????危????????
????????????????????
??????1??????????? SELECT ????
??????2??????(???????)?????????????围???
??????3???????????? WHERE ?????????????谐???
????????????????????????????????????????????????????????????????????????
??????????????????????
??????1??????????? INSERT/UPDATE/DELETE ????
??????2?????小(???????)
??????3?????????????????????????????? WHERE ?????
??????????
?????emp???empno??????危?????????emp_empno_idx???械?????????create index ?????? on ????(??危?...)
????create index emp_empno_idx
????on emp(empno);
?????emp???ename??job?????危?????????emp_ename_job_idx??????????/????????
????create index emp_ename_job
????on emp(ename??job);
?????????where???????job?????????
?????????where???????ename???????
????????????????ename??job
???????????????????胁?????泄??????????insert/update/delete????????????????
???????emp_empno_idx??emp_ename_job_idx??????drop index ??????
????drop index emp_empno_idx;
????drop index emp_ename_job_idx;