How to avoid Automatic Rounding of number column?
In 10g 10.2.0.4 database I am seeing the below automatic rounding issue. How can I remove this automatic rounding.
create table test (a number(28, 12))
insert into test values (7051743.889999999665)
select * from test
Result:
7051743.89
But I want the result as what I entered i.e. 7051743.889999999665 so please guide how can I achieve this.