Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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.