title: Oracle: How to sort the query to get months in proper sequence
body: <p>I am working on an report for which am calling a function from front end. I am getting start month information as numbers starting from 1 to 12 and so am using </p>
  
  <pre><code>substr(to_date(START_MONTH,'MM'),4,3)
  </code></pre>
  
  <p>to get month in the form of Jan, Feb etc, now in my function am grouping by start month and then ordering by start month and so in the output am getting values like </p>
  
  <p>Apr, Aug, Dec as it is ordering by First alphabet of the month, how can I get correct order starting from Jan to Dec?</p>
  
  <p>Any suggestions?</p>
  
  <p>Also how to sort number so that 2 comes after 1 and not 10 after 1? </p>