sql - Using Order By in Oracle 11g but the list is not orderred -


I have an order ID column and values ​​are a mixture of digits such as 1,2,3 to 4 digits like 3456 When I ask and order the order and order order using the Order ID, OrderId is not ordered by the order.

Instead of showing: 1,8,10,20,70,111,2345,4567

This is showing: 1,111,20,2345,4567,70,8 etc. < / P>

Is there a way to properly arrange this ID? My simple query is like this: