Oracle数据库 nlssort函数中排序参数为空时,会按照什么规则进行排序?

Oracle数据库执行如下用例:
drop table qz_people;
create table qz_people (id int, name varchar2(30));

insert into qz_people values (42, ‘Arthur Dent’);
insert into qz_people values (44, ‘Tricia mcmillan’);
insert into qz_people values (43, ‘Ford prefect’);
insert into qz_people values (45, ‘Zaphod Beeblebrox’);
查询结果如下:
select name from qz_people order by nlssort(name, null);

NAME

Arthur Dent
Zaphod Beeblebrox
Ford prefect
Tricia mcmillan

请问这个节结果的顺序是按照什么规则排的呢?

讨论数量: 0
(= ̄ω ̄=)··· 暂无内容!

讨论应以学习和精进为目的。请勿发布不友善或者负能量的内容,与人为善,比聪明更重要!