title: Oracle SQL pivot query
body: <p>I have data in a table as seen below:</p>
  
  <pre><code>MONTH VALUE
  
  1     100
  2     200
  3     300
  4     400
  5     500
  6     600
  </code></pre>
  
  <p>I want to write a SQL query so that result is given as below:</p>
  
  <pre><code>MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN
  100       200       300       400       500       600
  </code></pre>