TRUNCATED formatting option: each line of the displayed output is truncated exactly at the length specified by the LINESIZE variable. : SERVEROUTPUT « SQL Plus « Oracle PL / SQL






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

TRUNCATED formatting option: each line of the displayed output is truncated exactly at the length specified by the LINESIZE variable.

  
SQL>
SQL> SET SERVEROUTPUT ON FORMAT TRUNCATED
SQL> SET LINESIZE 20
SQL> BEGIN
  2   DBMS_OUTPUT.PUT_LINE('After the first 20 characters please');
  3   DBMS_OUTPUT.PUT_LINE('continue on the second line');
  4  END;
  5  /
After the first 20 c
continue on the seco

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