set serveroutput on format truncated : serveroutput « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. serveroutput
SQL>
SQL>
SQL> set serveroutput on format truncated
SQL> exec dbms_output.put_line( '     Hello     World     !!!!!' );
     Hello     World     !!!!!

PL/SQL procedure successfully completed.

SQL>








29.26.serveroutput
29.26.1.serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls go into the bit bucket
29.26.2.Setting up the server to communicate
29.26.3.set serveroutput on size 1000000;
29.26.4.SET SERVEROUTPUT ON for PL/SQL
29.26.5.set serveroutput on format truncated
29.26.6.set serveroutput on format word_wrapped