Oracle 根据列值排序

利用decode函数 order by DECODE(hist.SERVICE_TYPE,'SEX','1','SIM','2','AEX','3','AIM','4','ALL','5'); 利用case when子句 select * from 表 order by (select case s