title: Oracle Column width for all columns
body: <p>One of the issue when executing a long statement for displaying various columns for example</p>
  
  <pre><code> select g.guestid, g.forename, g.surname, b.bookingid,
   b.arrivedate, b.departdate, br.floorno, br.roomno from...
  </code></pre>
  
  <p>the column sizing on linux terminal seems to be an issue. For example the Forename VarChar(80) column takes up much of the width of the screen when executing the above statement and one way to cut it down would be through:</p>
  
  <pre><code>SET COLUMN FORENAME FORMAT A10
  </code></pre>
  
  <p>for example. However, many columns would need to be repeatedly go through this which is quite long. i.e.</p>
  
  <pre><code>SET COLUMN FORENAME FORMAT A10
  SET COLUMN SURNAME FORMAT A10
  </code></pre>
  
  <p>and so on...</p>
  
  <p>Is there a way to say adjust column width according to text width so that every fits in nicely. and not like this..</p>
  
  <p><img src="https://i.stack.imgur.com/iZRSU.png" alt="enter image description here"></p>
  
  <p>I would prefer some solution that does not involve the use of FUNCTIONS.</p>