1.GRANT //授权
GRANT CREATE VIEW TO SCOTT;
2.CREATE VIEW
CREATE OR REPLACE VIEW V1 AS
SELECT * FROM EMPNO,SAL FROM EMP;
3.SELECT VIEW // VIEW IS VIRTUAL,THIS IS A VIRTUAL TABLE;
SELECT * FROM V1;
4.ANOTHER NAME
CREATE OR REPLACE V2(ID,NAME,SAL) AS SELECT EMPNO,ENAME,SAL FROM EMP;
SELECT * FROM V2 WHERE ID=7369;
5.SELECT TABLE_NAME,COLUMN_NAME,UPDATETABLE,INSERTABLE,DELETEABLE FROM TABLE WHERE TABLE_NAME='EMP';
6. ADD VIEW DATA
INSERT INTO VIEW VALUES(1,'TOM',15);
7.WIDTH READ ONLY
CREATE OR REPLACE VIEW V3 AS SELECT ENAME FROM EMP WITH READ ONLY;
8.WITH CHECK OPTION //CHECK VIEW 约束就是where后面的条件
CREATE OR REPLACE VIEW V4 AS SELECT ENAME,SAL FROM EMP WHERE DEPTNO=20 WITH CHECK OPTION CONSTRAINT VM_CK;
8.//复杂视图
CREATE OR REPLACE VIEW V4 AS SELECT D.DNAME,E.ENAME FROM EMP E.DEPT D WHERE D.DEPTNO=E.DEPTNO GROUP BY DEPTNO;
SELECT * FROM V4;