title: Oracle Convert Rows to Columns
body: <p>I have folowing Dataout put from my query</p>
  
  <pre><code>**Date**    **HIGH**  **LOW**       **IMAGE**      **TYPE**
  1/28/2012     69         42          1.jpg           SUN
  1/29/2012     70         42          2.jpg           MSUN
  </code></pre>
  
  <p>I want to Convert this Output into</p>
  
  <pre><code>**1/28/2012**       **1/29/2012**
  1.jpg                    2.jpg    
  Sun                       MSUN
  69                         72  
  42                         42
  </code></pre>
  
  <p>Here is My query</p>
  
  <pre><code>SELECT 
     W_DATE,HIGH, LOW, 
     W_TYPE, IMAGE
  FROM WEATHER
  ORDER BY W_DATE ASC
  </code></pre>
  
  <p>And Also I have multiple dates in rows i want to display only 4 dates and they should change when system date is chanaged</p>