-
Error in To_char
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|