Oracle database, the field is VARCHAR2 type string, but in fact, the number is stored, the order by the sort result, there must be a problem

Such as:

11 is in front of 9, because it is sorted according to string (so 1 is definitely ahead of 9), not sorted by the actual size of the number.

What to do now.

Use Orale SQL keyword: cast, convert varchar2 to int, but only if the field is cast, it must be the form of a number, not a non-numeric value, otherwise it will be reported as "Invalid number" error.

SELECT * from Biz_dict t where t.biz_type= ' DEGREE ' ORDER by cast (t.biz_value as int)

In Oracle's SQL query interface, the input cast will automatically prompt the keyword,