Oracle sql中文排序的三种方式

按照笔划排序

select * from table order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M');

按照部首排序

select * from table order by nlssort(name,'NLS_SORT=SCHINESE_RADICAL_M');

按照拼音排序，此为系统的默认排序方式

select * from table order by nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');