How can I sort a table by a column varchar2 with characters in varying cases: upper, lower, numeric string

For example, when I do an order by the column NAME, the data of the column are:

```
ANNIE
BOB
Daniel
annie
bob
1abc

```

The expected result is:

```
1abc    
ANNIE
annie
BOB
bob
Daniel

```