title: Custom order in Oracle PL/SQL
body: <p>I have an oracle query in which and i want the result to be in custom order 'SENIOR DIRECTOR', 'DIRECTOR', 'MANAGER', 'EMPLOYEE' which is from the field GRADE_DESCRIPTON. I am using the below query.</p>
  
  <p>However I am not getting the desired result 
  The order of the result im getting is  'SENIOR DIRECTOR','MANAGER', DIRECTOR,'EMPLOYEE'</p>
  
  <pre><code>SELECT DISTINCT GRADE_DESCRIPTION
        , HIRING_FORECATS.*  
  FROM GRADE_MASTER left join     HIRING_FORECATS 
     ON (HIRING_FORECATS.GRADE = GRADE_MASTER.GRADE_DESCRIPTION 
          and HIRING_FORECATS.LOCATION = 'HO' )   
   order by decode    
   (GRADE_MASTER.GRADE_DESCRIPTION, 'SENIOR DIRECTOR', 'DIRECTOR', 'MANAGER', 'EMPLOYEE')
  </code></pre>
  
  <p>Any Suggestions??</p>