SQL> select * from t4 order by name;
NAME NAME2
---------- -----------------------------------------------
bai xiao
test test
test1 test1
aa
SQL> select * from t4 order by name nulls first;
NAME NAME2
---------- -----------------------------------------------
aa
bai xiao
test test
test1 test1
SQL> select * from t4 order by name nulls last;
NAME NAME2
---------- -----------------------------------------------
bai xiao
test test
test1 test1
aa
NAME NAME2
---------- -----------------------------------------------
bai xiao
test test
test1 test1
aa
SQL> select * from t4 order by name nulls first;
NAME NAME2
---------- -----------------------------------------------
aa
bai xiao
test test
test1 test1
SQL> select * from t4 order by name nulls last;
NAME NAME2
---------- -----------------------------------------------
bai xiao
test test
test1 test1
aa