title: SQL result from Rows to Column
body: <p>How to get sql result by using sqlplus in shell script in column form like below. Please note 1st column is Header and 2nd column the row value (only 1 row need to be displayed as no other matching.)</p>
  
  <pre><code>STAT_DATE       20180515
  
  SERVER_NAME   abcd3363
  
  Hits1         112389
  
  Hits2         659405
  </code></pre>
  
  <p>Whereas simple by select command I get as below.</p>
  
  <pre><code>STAT_DATE   SERVER_NAME     Hits1     Hits2
  
  ----------- --------------  -------- --------
  
  20180515    abcd3363        112389   659405  
  </code></pre>