title: Oracle SQL: Transpose Columns to Rows
body: <p>There have been some questions on this but I couldn't find a relevant result for me. I have a query that gives me 2 columns of results:</p>
  
  <pre><code> Day            Tot_dLS   
   01-Sep-12      10000
   02-Sep-12      9920
  </code></pre>
  
  <p>I want to transpose the Date so it reads:</p>
  
  <pre><code>01-Sep-12    02-Sep-12 
  10000         9920
  </code></pre>
  
  <p>Is this possible?</p>