title: Oracle ORDER BY not working
body: <p>I am trying to use Oracle's ORDER BY statement with the following query...</p>
  
  <pre><code>SELECT   TO_CHAR(transaction_date, 'MON-YYYY') AS MONTHS
  FROM     transaction_upload
  WHERE    EXTRACT(YEAR FROM transaction_date) = 2009
  GROUP BY TO_CHAR(transaction_date, 'MON-YYYY')
  ORDER BY MONTHS;
  </code></pre>
  
  <p>The results that I'm getting however are:</p>
  
  <pre><code>MONTHS
  -----------------
  APR-2009
  AUG-2009
  DEC-2009
  FEB-2009
  JAN-2009
  JUL-2009
  JUN-2009
  MAR-2009
  MAY-2009
  NOV-2009
  OCT-2009
  SEP-2009
  </code></pre>
  
  <p>What am I doing wrong?</p>