Originally posted by jmodic
Your values are stored in the database with full precision, but your querying client tool is configured to round the retrieved numbers.
It is stored in db as 12000000000.22 not as 12000000000.219999.Actually I have found that it starts misbehaving for larges values.Like I faced this problem for 12000000000.22. Surprisingly it's showing correct result for 12000000000.44 0r 12000000000.33 . Its only giving problem when I update that value by 12000000000.22 or 12000000000.55. Since I have updated it with exact value ie. 12000000000.22,so it should give me the same value in Pro*C as well, moreover why only these two values give me wrong results.