Oracle 中文字段进行排序的sql语句
程序员文章站
2024-02-10 14:30:10
1）按笔画排序 select * from table order by nlssort(columnname,'nls_sort=schinese_stroke_m')...
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');
上一篇： sql游标使用的一个例子
下一篇： js聚焦问题