ORACLE按照汉字拼音、笔划、部首排序。

WITH
T AS (
SELECT '一' S FROM DUAL UNION ALL
SELECT '二' S FROM DUAL UNION ALL
SELECT '三' S FROM DUAL UNION ALL
SELECT '四' S FROM DUAL UNION ALL
SELECT '五' S FROM DUAL UNION ALL
SELECT '六' S FROM DUAL UNION ALL
SELECT '七' S FROM DUAL UNION ALL
SELECT '八' S FROM DUAL UNION ALL
SELECT '九' S FROM DUAL UNION ALL
SELECT '十' S FROM DUAL  
)
SELECT S,
NLSSORT(S,'NLS_SORT = SCHINESE_PINYIN_M') 拼音,
NLSSORT(S,'NLS_SORT = SCHINESE_STROKE_M') 笔划,
NLSSORT(S,'NLS_SORT = SCHINESE_RADICAL_M') 部首
FROM T ORDER BY 拼音;