Serveroutput可以打开dbms_output的输出,具体操作如下:
- SQL> show serveroutput
- serveroutput OFF
- SQL> begin
- 2 for e in (select * from scott.emp) loop
- 3 dbms_output.put_line(e.empno || ' is: ' ||e.ename);
- 4 end loop;
- 5 end;
- 6 /
- PL/SQL procedure successfully completed.
- SQL> set serveroutput on;
- SQL> show serveroutput
- serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
- SQL>
- SQL> list
- 1 begin
- 2 for e in (select * from scott.emp) loop
- 3 dbms_output.put_line(e.empno || ' is: ' ||e.ename);
- 4 end 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.