Shulou(Shulou.com)06/01 Report--

When our order sorting can't achieve what we want, try the function NLSSORT.

He sorts not only by last name, but also by first name:

Nls_param is used to specify language features in the format nls_sort = sort,nls_ sort with values of:

Sort by radical: SCHINESE_RADICAL_M

Sort by stroke: SCHINESE_STROKE_M

Sort by Pinyin: SCHINESE_PINYIN_M

TEST=# select * from helei order by nlssort (name,'NLS_SORT= SCHINESE_PINYIN_M')

NAME

-

A Hong

Cao Li

Chen Lu

Chen Nan

Chen Zhe

Hatred of three

The first year of junior high school

Chu Zhe

He Li

Wang Ming

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.