1、使用拼音排序
select * from TableName order by nlssort(column,'NLS_SORT=SCHINESE_PINYIN_M');
2、使用笔画排序
select * from TableName order by nlssort(column,'NLS_SORT=SCHINESE_STROKE_M');
3、使用偏旁部首排序
select * from TableName order by nlssort(column,'NLS_SORT=SCHINESE_RADICAL_M');
select * from v$nls_parameters 查看nls_sort参数设置