Dear All,

I have a problem while trying to store a big value in number datatype.

I have a column of type number(20,2). so we can give precision 18 and scale 2 (in oracle). while im trying to insert 18 precision and 2 scale as 123456789012345678.99, it is automatically converting to 1.23456789012346E17. so even when im trying to retrieve by using the following query:

"select to_char(billed_threshold,'999999999999999999.99') from claim_line"

im getting only 123456789012346000.00 (the fourth precision from the right getting rounded and the remaiing becomes zero). How to go about that. I want to store and retrieve as it is. i can not change the datatype to varchar2 now, because it is already documented to client.

(its working fine till 1234567890123.99. ie., till number(15,2) its ok)

Please help me to sort out this issue.

Thanks in advance.

Best Regards,
A. Saravanan.

__________________
Best Regards,
Saran.

hi,
i tried your problem in Oracle 9i and its working just fine and giving the exact precision you want, which version of Oracle are you using.

Regards
M