Oracle to_number (string to number)

 

This cannot be avoided during sorting in queries. Generally, we add sorting fields when writing SQL statements.

If the sorting field is a string, it is a little troublesome.

For example, a numeric field should have been designed to be integer type, but to be varcher type.

There is a problem with sorting. If it is a number, he will first take the highest bid and then take another 2nd bits.

For example, the descending order of 8 to 12 is 8 to 12 instead of the expected 12 to 8.

If there is an empty string, the empty string is the first one.

Therefore, it is normal to convert the string into numbers in order.

To_number ()

 

Select * From cx_faq_main t where T. Counter is not null order by to_number (T. Counter) DESC