创建视图
CREATE VIEW empvu10
AS SELECT empno,ename,job
FROM emp
WHERE deptno=10;
查看视图
SELECT * FROM empvu10;
修改视图
CREATE OR REPLACE VIEW empvu10
(employee_number,employee_name,job_title)
AS SELECT empno,ename,job
FROM emp
WHERE deptno=10;