Hi All,


Iam executing the below statement with value as two digit number.



Select to_number(to_char('10','99999999,99')) from dual ;


Iam getting the output as 10

when run for 3 digit number iam getting Invalid number.

Select to_number(to_char('125','99999999,99')) from dual ;

Like to kknow what makes this happen or how to rectify it.


Thanks!

Tarus