select * from table order by nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');
按笔画排序
select * from table order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M'
);
按部首排序
select * from table order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M'
);
看nlssort翻译后的字符信息
select nlssort(name,'NLS_SORT=SCHINESE_STROKE_M') from table;
------------
8B5C00000010001
3B2900000010001
与nlssort有关的数据字典
desc v$nls_valid_value;
select * from v$nls_valid_value;
select distinct parameter from v$nls_valid_value;
创建字符排序index
create index index_word_name on list (nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M'));