Oracle PL/SQL Tutorial/SQL PLUS Session Environment/serveroutput
Содержание
serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls go into the bit bucket
<source lang="sql">
SQL> SQL> set serveroutput on size 1000000 format wrapped SQL> SQL></source>
set serveroutput on format truncated
<source lang="sql">
SQL> SQL> SQL> set serveroutput on format truncated SQL> exec dbms_output.put_line( " Hello World !!!!!" );
Hello World !!!!!
PL/SQL procedure successfully completed. SQL></source>
set serveroutput on format word_wrapped
<source lang="sql">
SQL> SQL> SQL> set serveroutput on format word_wrapped SQL> exec dbms_output.put_line( " Hello World !!!!!" ); Hello World !!!!! PL/SQL procedure successfully completed.</source>
SET SERVEROUTPUT ON for PL/SQL
<source lang="sql">
SQL> SQL> SET ECHO ON SQL> SET SERVEROUTPUT ON SQL> DECLARE
2 age NATURAL; 3 4 BEGIN 5 age := 10; 6 DBMS_OUTPUT.PUT_LINE("age:"); 7 DBMS_OUTPUT.PUT_LINE(age); 8 END; 9 /
age: 10 PL/SQL procedure successfully completed. SQL></source>
set serveroutput on size 1000000;
<source lang="sql">
SQL> SQL> set serveroutput on size 1000000; SQL></source>
Setting up the server to communicate
By default, server output is turned off.
<source lang="sql">
Set serveroutput on</source>