title: How to get coumn names without getting truncated in SQLPLUS
body: <p>How to do I get column names without getting truncated in SQLPLUS in Unix for select statement. This might look like duplicate question, but I have been searching for hours but couldn't find a convenient solution.</p>
  
  <p>So far what I have found is </p>
  
  <pre><code>COLUMN COLUMN_NAME FORMAT SIZE;
  </code></pre>
  
  <p>Or  </p>
  
  <pre><code>SELECT COLUMN1|| ',' || COLUMN2 || ',' || COLUMN3 FROM TABLE;
  </code></pre>
  
  <p>Both involves hardcoding,Is there any simpler solution without hardcoding.   </p>
  
  <p>Sorry for making it hard</p>
  
  <pre><code>Query: select * from Employee;
  </code></pre>
  
  <p>It has column names as Name,Salary,Age</p>
  
  <p>What I get is:</p>
  
  <pre><code> Name   Sala  Ag
   Steve  1000  30
   John   2000  25
  </code></pre>
  
  <p>What I want is:</p>
  
  <pre><code> Name  Salary Age
   Steve 1000   30
   John  2000   25
  </code></pre>