Oracle top order (colname) does not give correct results for columns without row

Question

If in oracle db there is a non-string column (i.e.: varchar, date) (col1) if:

select * from table order by col1 asc

he orders correctly. (i.e., for the date he orders from the oldest to the last, for the numeric, from the lowest to the highest) But if I do this, the select * from table order by upper(col1) asc ordering is incorrect.

What is the reason for this behavior?

Answer 1

UPPER . col1 - , , . UPPER , , col1. col1 ,

• UPPER (9) '9'
• UPPER (10) '10'

"9" "10", , -, , .

col1 , , ?