復制代碼 代碼如下:

sqlplus / as sysdba

復制代碼 代碼如下:

grant create view to scott
以scott用戶登錄oracle

復制代碼 代碼如下:

conn scott/tiger

復制代碼 代碼如下:

CREATE OR REPLACE VIEW myview AS
SELECT * FROM emp where deptno = 20;