Column totals sum, min, max and avg grayed out

[Marcel Hoefs]

Version 12.0.0.1811

Column totals SUM, MIN, MAX and AVG in the data grid remain grayed out. Only COUNT (and none, clear of course) are selectable.

This seems a strange side effect of the preference "Number fields to_char" which I need to prevent scientific notation of large numbers (e.g. 3,87137916457719E17 instead of 387137916457718915).

In the post Bug(?) 5: inconsistent large number behavior I described a number of others annoyances caused by this preference:
- test window errors and large numbers
- sorting of the datagrid and large numbers.

When will there be support for large numbers (as NUMBER) in PL/SQL Developer? If the database supports numbers with 38 digits then surely the IDE for PL/SQL developers should support this too?

 

[Marco Kalter]

This improvement has not yet been implemented and is still on the list of enhancement requests.

 

[Marcel Hoefs]

Good to hear that this enhancement/bug is on the list.

For me this bug degrades a significant portion of useful features in PL/SQL Developer. So hopefully this will be fixed soon!