WORD_WRAPPED option for FORMAT wraps each line to the length specified by the value of the LINESIZE variable : SERVEROUTPUT « SQL Plus « Oracle PL / SQL






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

WORD_WRAPPED option for FORMAT wraps each line to the length specified by the value of the LINESIZE variable

  
SQL>
SQL> SET SERVEROUTPUT ON FORMAT WORD_WRAPPED
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
characters please
continue on the
second line

PL/SQL procedure successfully completed.








Related examples in the same category

1.TRUNCATED formatting option: each line of the displayed output is truncated exactly at the length specified by 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