title: Set line width for oracle cmd line
body: <p>I am using <code>SET LINESIZE 32767</code> for displaying properly data in tables, however there is a table that does not accommodate all the columns, also what is the difference between linesize and <code>SET NUM</code></p>
  
  <p><strong>TABLE</strong></p>
  
  <pre><code>CREATE TABLE STAFF(
  EMP_ID NUMBER NOT NULL,
  EMP_NAME VARCHAR2(20),
  EMP_DOB DATE,
  EMP_TEL VARCHAR2(20),
  EMP_EMAIL VARCHAR2(50),
  EMP_ADDR VARCHAR2(100),
  EMP_HIREDATE DATE,
  EMP_ENDDATE DATE,
  EMP_SALARY NUMBER(7,2),
  EMP_SUPERVISOR NUMBER,
   JOB_CODE NUMBER,
   BRA_CODE NUMBER);
  </code></pre>
  
  <p><strong>INSERT SAMPLE</strong></p>
  
  <pre><code>INSERT INTO STAFF VALUES (NULL,'Andres Baravalle',to_date('25/03/1975','dd/mm/YYYY'),'723 3403-2817','andres.baravalle@live.co.uk','P.O. Box 879, 1742 Porttitor',to_date('15/04/2007','dd/mm/YYYY'),to_date('19/02/2007','dd/mm/YYYY'),49670,NULL,1,10);
  </code></pre>
  
  <p><code>SELECT * FROM STAFF;</code> yields the following</p>
  
  <p><img src="https://i.stack.imgur.com/kfrEA.jpg" alt="output"></p>
  
  <p>Edit----</p>
  
  <p>Guys how can i get rid of all the space in the timestamp attributes</p>
  
  <p><img src="https://i.stack.imgur.com/Nfwmh.png" alt="Get rid of space"></p>