Setting the Line Size

Setting the Line Size

You set the number of characters in a line using the SET LINESIZE command. Set the line size to 50 lines using the following SET LINESIZE command and run the new query shown in the following example:

 SQL>  SET LINESIZE 50  SQL>  SELECT * FROM customers;  CUSTOMER_ID FIRST_NAME LAST_NAME DOB ----------- ---------- ---------- --------- PHONE ------------  1 John Brown 01-JAN-65 800-555-1211  2 Cynthia Green 05-FEB-68 800-555-1212  3 Steve White 16-MAR-71 800-555-1213  4 Gail Black 800-555-1214  5 Doreen Blue 20-MAY-70 

The lines don t span more than 50 characters.

Note  

The maximum number for the line size is 32,767.