Make sure SQL*Plus SERVEROUTPUT setting is on : SERVEROUTPUT « SQL Plus « Oracle PL / SQL






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

Make sure SQL*Plus SERVEROUTPUT setting is on

 

SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE('hello, world');
  3  END;
  4  /
hello, world

PL/SQL procedure successfully completed.

SQL>
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.SET SERVEROUTPUT ON SIZE 1000000