The SET SERVEROUTPUT Command : SERVEROUTPUT « SQL Plus « Oracle PL / SQL






The SET SERVEROUTPUT Command

  

SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2      dbms_output.put_line('This is the first line');
  3      dbms_output.put_line('This is the second line');
  4      dbms_output.put_line('This is the last line');
  5  END;
  6  /
This is the first line
This is the second line
This is the last line

PL/SQL procedure successfully completed.

   
  








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.SET SERVEROUTPUT OFF/ON
4.SET SERVEROUTPUT ON SIZE 1000000
5.Make sure SQL*Plus SERVEROUTPUT setting is on