oracle的TO_NUMBER函数

发布网友发布时间：2024-10-02 10:50

共1个回答

热心网友时间：2024-10-04 22:00

to_number(‘123.45‘) from dual;TO_NUMBER(‘123.45‘)------------------- 123.45SQL> select to_number(‘123.45‘, ‘9999.99‘) from dual;TO_NUMBER(‘123.45‘,‘9999.99‘)----------------------------- 123.45SQL> select to_number(‘12‘, ‘99‘) from dual;TO_NUMBER(‘12‘,‘99‘)-------------------- 12SELECT TO_NUMBER(‘$12,123.23‘,‘$999,999.99‘) FROM DUAL;SQL>SQL>SQL>SQL>Do calculation after the conversion
SQL> select to_number(‘123.45‘) + 2 from dual;TO_NUMBER(‘123.45‘)+2--------------------- 125.45SQL> SELECT TO_NUMBER(‘-$12,345.67‘, ‘$99,999.99‘) FROM dual;TO_NUMBER(‘-$12,345.67‘,‘$99,999.99‘)------------------------------------- -12345.67SQL>
oracle的TO_NUMBER函数

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com