Number(22) display

[R]

Hello,

I have an Oracle table, with NUMBER(22) attributes.
Some values appears as 1,20490421889003E15 in the View/Edit data screen of PL/SQL developer.
Does somebody know how to display the entire value of my numbers ? Is it an Oracle setting or a PL/SQL developer setting ?

Thanks.

 

[BWendling]

it will probably show up with full digits in Oracle SQL Developer.

It's the same for "too many" mantissa digits which will be cut off in PL/SQL Developer, too.

I wish PL/SQL Developer would always show all digits and never use scientific notation.

 

[Marco Kalter]

This is a floating point precision issue. For the SQL Window you can enable the "Number fields to_char" preference (Tools > Preferences > SQL Window). This way the numbers are converted to character strings on the server with full precision.

 

[Vinny]

One problem with converting them to strings vi to_char() is that they do not sort properly in the SQL window. i.e. 11 comes before 2.

 

[R]

Thank you Marco, that solves my problem