Large integers in SQL Window

[Fernando N]

Hi,

I've got a NUMBER(18) field in a table. I've inserted "900000000000000001" in it.

When I do "select * from table" I see "9E17", which is not correct (as it is not 90..0 but 90..1).

If I do "select to_char(field) from table" I see the correct figure, so the problem is of PL/SQL Developer.

Is there any way I can see the full figure? It is really a problem if I do "Edit data" as I don't know what number was!

Thank you!

 

[Marco Kalter]

This is a known floating point precision restriction. You can however enable the "Number fields to_char" preference (Tools > Preferences > SQL Window tab page). That should do the trick.

 

[Steffen B.]

Hello,

I have the same problem with a Test Window. There is a number(18) field, but the Test Window does not work correctly with it. The number is 500000207730070001 for example. The Test Window refers it to my function as 500000207730070000. In a sqlplus window it works correctly. In my opinion this is a bug. Is there a plan to fix it?

Regards

Steffen

 

[Marco Kalter]

We'll look into this. At the moment you can only specify a to_char() in the field list.

 

[Steffen B.]

OK, please give me a short information of your results. I think this behaviour is a little dangerous because there is no obviously error.
I was searching for hours in my code for the malfunction...