形如'1,234,567,345.00'的字符串如何转化成NUMBER?

Question

如标题

Answer 1

SQL> select to_number(replace('1,234,567,345.00',',','')) from dual;TO_NUMBER(REPLACE('1,234,567,345.00',',',''))
---------------------------------------------
                                   1234567345已用时间:  00: 00: 00.30
SQL>

Answer 2

SQL> select to_number('1,234,567,345.00','999,999,999,999.999') from dual;TO_NUMBER('1,234,567,345.00','999,999,999,999.999')
---------------------------------------------------
                                         1234567345已选择 1 行。