我有一个oracle查询,我希望结果是自定义的“高级主管”,“董事”,“经理”,“雇员”,来自GRADE_DESCRIPTON领域.我正在使用以下查询.

但是我没有得到理想的结果
结果的顺序是“高级主管”,董事,“员工”

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')

有什么建议么？？

ORDER BY DECODE(
         GRADE_MASTER.GRADE_DESCRIPTION,1,2,3,'EMPLOYEE',4,5)