Oracle 中文字段进行排序的sql语句

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’);