Oracle 有趣排序包括那些

按拼音排序

 

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