oracle sql 按照汉字规则排序

-- 按照笔划排序
select * from traveler_info order by nlssort(traveler_name, 'nls_sort=schinese_stroke_m');
-- 按照部首排序
select * from traveler_info order by nlssort(traveler_name, 'nls_sort=schinese_radical_m');
-- 按照拼音排序，此为系统的默认排序方式
select * from traveler_info order by nlssort(traveler_name, 'nls_sort=schinese_pinyin_m');

 

转载于:https://www.cnblogs.com/pumushan/p/4661614.html