Oracle:Serveroutput-Oracle之旅
Serveroutput可以打开dbms_output的输出，具体操作如下：[*]SQL> show serveroutput
[*]serveroutput OFF
[*]SQL> begin
[*]2for e in (select * from scott.emp) loop
[*]3 dbms_output.put_line(e.empno || ' is: ' ||e.ename);
[*]4end loop;
[*]5end;
[*]6/
[*]
[*]PL/SQL procedure successfully completed.
[*]
[*]SQL> set serveroutput on;
[*]SQL> show serveroutput
[*]serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
[*]SQL>
[*]SQL> list
[*]1begin
[*]2for e in (select * from scott.emp) loop
[*]3 dbms_output.put_line(e.empno || ' is: ' ||e.ename);
[*]4end loop;
[*]5* end;
[*]SQL> /
[*]7369 is: SMITH
[*]7499 is: ALLEN
[*]7521 is: WARD
[*]7566 is: JONES
[*]7654 is: MARTIN
[*]7698 is: BLAKE
[*]7782 is: CLARK
[*]7788 is: SCOTT
[*]7839 is: KING
[*]7844 is: TURNER
[*]7876 is: ADAMS
[*]7900 is: JAMES
[*]7902 is: FORD
[*]7934 is: MILLER
[*]
[*]PL/SQL procedure successfully completed.
[*]
[*]SQL>
——
To be continue.
页:
[1]