SET SERVEROUTPUT ON SIZE 1000000 : SERVEROUTPUT « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. SERVEROUTPUT

SET SERVEROUTPUT ON SIZE 1000000

 

SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> BEGIN
  2    dbms_output.put_line('Hello World.');
  3  END;
  4  /
Hello World.

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.WORD_WRAPPED option for FORMAT wraps each line to the length specified by the value of the LINESIZE variable
2.TRUNCATED formatting option: each line of the displayed output is truncated exactly at the length specified by the LINESIZE variable.
3.The SET SERVEROUTPUT Command
4.SET SERVEROUTPUT OFF/ON
5.Make sure SQL*Plus SERVEROUTPUT setting is on