How can i stop numbers showing in scientific format

[SaKa]

in SQL window when i query a number type column, i get both numbers and scientific formatted rows. eg:- -4.5E-5

is there a way to stop this showing in this scientific format please?

Thanks in advance.
Sak

 

[Marco Kalter]

You can go to Preferences > SQL Window and enable the "Number fields to_char" option to display the number values with full Oracle precision in the SQL Window. All number fields will now be converted to character fields on the server.

 

[SaKa]

Ok thanks, I will give it a try.

 

[GiorgioC]

Setting the "Number fields to_char" option causes a problem: if you try to sort the field by clicking on the header, the ordering is incorrect, as it treats numbers as strings (2000 comes before 3). I'd like to see the numeric fields in their real precision in a next version. Is it possible to add this behavior in future updates?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Jason McCleskey]

Just a bump on this conversation to say I would like this too. My employer just recently licensed Pl/Sql Dev to replace Toad. One immediate nuisance is that the database we're in has many key ids that are 38 digits longs and we also export out to Excel a lot.

If we check the "Number fields to_char" option then it displays properly but when we export to Excel every number field gets formatted as a string and users can't easily use the number formats in Excel to reformat fields such as amounts etc...

If we un-check the "Number fields to_char" then those key ids display (and export) with scientific notation. For those fields we need to be able to see the full 38 digits in the cases where we we are querying them.

An option that would allow PlSql Dev to turn off the use of scientific notation would be GREAT!

Thanks!
Jason McCleskey