一，二，三（转）1,2,3，oralce

      SELECT
                                  DECODE(SUBSTR(PC,2,1),
                                  '一',1,
                                  '二',2,
                                  '三',3,
                                  '四',4,
                                  '五',5,
                                  '六',6,
                                  '七',7,
                                  '八',8,
                                  '九',9,1) ORD,PC
                                  FROM (SELECT BSFACILITIES_PC PC
                                   FROM BO_BSFACILITIES
                                  GROUP BY BSFACILITIES_PC) ORDER BY ORD