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
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