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