problem with display numeric values

[PeTe]

I have problem with display numeric values in SQL Window, Test Window and Report Window.

I have table test with column:
max number(20,12)
nd execute:

insert into test values (1433.143049998981)

When I try:

declare
  x number;
begin
  select max into x from test;
  dbms_output.put_line(x);
end;

everything look good.

But

select max from test;

in SQL Window, Test Window and Report Window give me:

max
---
1433,143049998980

Suggestion: maby PLSQL Developer include comma into precision???

 

[Marco Kalter]

This problem is caused by floating point precision. If you enable the SQL Window preference "Number fields to_char" (Tools > Preferences > SQL Window tab page), these high-precision numbers will be converted to strings on the server, using the Oracle NLS settings, and without losing precision.

 

[PeTe]

It's working. Thanx!