oracle视图

SQL> grant create view to scott;

Grant succeeded.

SQL> conn scott/tiger
Connected.
SQL> create or replace view v_emp_deptno as select empno,ename,job,sal from emp where sal>3000;

View created.

SQL> select * from v_emp_deptno;

     EMPNO ENAME      JOB              SAL                                      
---------- ---------- --------- ----------                                      
      7839 KING       PRESIDENT       5000                                      

SQL> conn system/manager
Connected.
SQL> set serveroutput on;
SQL> begin
  2  dbms_output.put_line('你好 世界！！！！');
  3  end;
  4  /
你好 世界！！！！                                                               

PL/SQL procedure successfully completed.

SQL> spool off;