ver 7.1.3.1381 Numeric display errors for large decimals

[limsk]

Am encountering some display errors with numeric columns with large decimal precision.

This example script should simulate the error:

create table example
(
CRR_VALU NUMBER(30,15)
);

insert into example (CRR_VALU) values (545.1);
insert into example (CRR_VALU) values (249.2);
insert into example (CRR_VALU) values (18886.56);

commit;

SQL> select * from example
2 /
CRR_VALU
--------------------------------
545.100000000000023
249.200000000000017
18886.560000000001300

We are using PL/SQL developer version 7.1.3.1381

Is this something that is fixed in version 8?

 

[Marco Kalter]

This is indeed a known floating point precision restriction. For the SQL Window you can enable the "Number fields to_char" preference (Tools > Preferences > SQL Window). This way the number values are converted to a character representation on the server with full Oracle precision.