Re: To_Number problem on PL/SQL 2.0 on AIX

In article <4kmv32$cku_at_news.magi.com>, msabbey_at_magi.com wrote:
>Try taking out the commas and see if it will work.
>
>
>Mike Chan <mikec_at_hk.super.net> wrote:
>
>>Hi,
 

>> I have problem on use funtion TO_NUMBER when I doing as following:
 

>> to_number('10,000,000');

Another work-around would be to supply a "picture" to the to_number function. This would allow you to keep the commas.

SQL> select to_number('10,000,000','99,999,999')   2 from dual
  3 /

TO_NUMBER('10,000,000','99,999,999')

                            10000000