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 拼音;
ORACLE按照汉字拼音、笔划、部首排序。
最新推荐文章于 2024-02-01 20:37:53 发布