select * from dual d order by nlssort(translate(lower(d.name),'abcdefghjklmnopqrstwxyz','啊八嚓大额发噶哈几卡拉吗呐哦扒七然仨他哇西呀杂'),'NLS_SORT=SCHINESE_PINYIN_M')
oracle 通过首字母(A - Z)排序
最新推荐文章于 2023-04-18 16:37:28 发布
select * from dual d order by nlssort(translate(lower(d.name),'abcdefghjklmnopqrstwxyz','啊八嚓大额发噶哈几卡拉吗呐哦扒七然仨他哇西呀杂'),'NLS_SORT=SCHINESE_PINYIN_M')