地址：广州市增城区中新镇慈岭村埔咀路20号
邮箱：sales@gzdairan.cn
新闻中心 News 分类>>
Oracle 中文字段进行排序的sql语句
2026-01-16 11:06:34
浏览次数： 次
返回列表 1）按笔画排序
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_STROKE_M')
2）按部首排序
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_RADICAL_M')
3）按拼音排序
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_PINYIN_M');
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_STROKE_M')
2）按部首排序
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_RADICAL_M')
3）按拼音排序
select * from Table order by nlssort(columnName,'NLS_SORT=SCHINESE_PINYIN_M');
