Number(24,13) displaying differently in SQL and Command Windows

[Splat]

Hiya, hope there is a simple setting to fix this, when if I select a value from a table (i.e 7265724.27) in the SQL window it is returns as above, but in the Command window it comes out with 7265724.2699999995500..

?????

 

[Marco Kalter]

This is a floating point precision issue. For the SQL Window you can enable the "Number fields to_char" option. For the Command Window there is no such option, so you would need to apply a to_char(field) yourself.

 

[William Robertson]

Just had the same problem myself. For example in a SQL window:

select 10000000000000.1 as testnum from dual
union all
select 100000000000000.1 as testnum from dual;

The second row (1e14 + 0.1) loses its decimal precision - but I need to see that information!

The "Number Fields TO_CHAR" setting is a bit of a blunt instrument because all numbers become left-aligned and I can't sort numeric columns in the grid any more.

Is there a preference setting for this, perhaps similar to the SQL*Plus NUMWIDTH and NUMFORMAT (or could we have one)?

 

[Marco Kalter]

There are no other settings at the moment. You can of course explicitly apply a to_char() to these fields in the SQL text.