Logarithmic display of 64bit integers

[James Sutton]

Even in the 64bit version of the client long integers are displayed in SQL Window results grid as a logarithmic value.

For example: 100000501001000000000014 is displayed as 1.00000501001E23. This is challenging for us because we use 64bit long integers for PKs in many of our systems and need to be able to copy and paste these values frequently when building queries.

I know that we can set the option to display numbers as to_char in the SQL Window but then we lose the ability to sum other numeric columns. Older versions of PL/SQL developer allowed us to attempt column sum functions on number columns that were formatted with to_char.

This means that we are constantly changing this preference back and forth throughout the day or that we have to remember to use to_char() on all our PKs for all queries.

It's a significant irritant for the entire team who have recently upgraded to version 12 and have lost this ability. Obviously, since we are using a 64bit OS with 64bit oracle drivers and a 64bit PL/SQL developer we would prefer to see 64bit long integers in their natural state, but I would support any change that would allow us to both see long integer values and sum numeric column in the SQL window at the same time without having to change the preferences each time.

Regards,

James.

 

[Marco Kalter]

If you go to Preferences > SQL Window you can enable the "Number fields to_char" option to display the number values with full Oracle precision in the SQL Window.

 

[Marcel Hoefs]

Hi Marco,

This is merely a workaround as it disables a lot of features related to numeric columns. Not just sorting but also e.g. the numeric aggregation features of the data grid. In the following posts I have described and tested a number of limitations in PL/SQL Developer caused by the limited support for large numbers:

Bug(?) 5: inconsistent large number behavior

Column totals sum, min, max and avg grayed out

I hope these limitations will be fixed soon!