Feature request: Number formats

[BWendling]

Hi,

when working with large numbers with 17 digits, even when whole integers, SQL window uses scientific notation and does not show anymore all digits. In companies, it's usual to work with large integer numbers (e.g. order numbers, part numbers, auto numbers) where all digits are important, especially the right ones which are suppressed in PL/SQL Developer. It's not feasible to convert these numbers TO_CHAR using SQL. In contrast, Oracle SQL Developer, a free product from Oracle, shows large numbers correctly.

Example:

drop table test;
create table test (a number(17));
insert into test values (12345678901234567);
select * from test;

A: 1.23456789012346E16

SQL window should offer a display format which either does not use scientific notation or still shows all digits.

 

[ScottMattes]

FWIW, and IMO, the number type should not be used for non-number fields (order/part/auto numbers, etc).

Having said that, PL/SQL Dev should show them "correctly".

 

[Marco Kalter]

You can enable the SQL Window preference "Number fields to_char". This way all number fields will be converted to a character representation on the server, using the full Oracle precision.

 

[swatford]

Switching to preference "Number fields to_char" destroys the numerical sort. I believe we need a product change to display large numbers as numbers.

 

[Marco Kalter]

Numerical sort for converted number fields will indeed require an update. This is on the to-do list.