Shulou(Shulou.com)06/01 Report--

If the values of string types are compared in oracle, incorrect comparison results may occur once the number of digits is different, such as 999 and 1000, which can only be correctly compared by using numeric values. Therefore, in order to prevent the occurrence of the above bug, it is recommended to use numerical comparisons, such as:

Select to_number ('123') from dual

Can be converted to int type comparison

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.