oracle数据库中文汉字排序

1、按照拼音排序： 

select * from your_table_name t order by nlssort(t.ordered_column_name,‘NLS_SORT=SCHINESE_PINYIN_M‘) 

2、按照笔画数排序： 

select * from your_table_name t order by nlssort(t.ordered_column_name,‘NLS_SORT=SCHINESE_STROKE_M‘) 

3、按照偏旁部首排序： 

select * from your_table_name t order by nlssort(t.ordered_column_name,‘NLS_SORT=SCHINESE_RADICAL_M‘) 

解释：SCHINESE_PINYIN_M====>Simplified Chinese Pinyin Mode