Numbers with high scale are diplayed incorrectly

[Sergey Rudyshin]

Hi, Marco!

numbers with high scale are diplayed incorrectly in "Version 12.0.7.1837 (32 bit)"
check this out

SQL> select cast ('0,1' as number (*,37)) n from dual;

                                       N
----------------------------------------
                    0,100000000000000006

The 64 bit version works fine though.

 

[Marco Kalter]

This is a floating point rounding issue. 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.

For the Command Window you would need to use the to_char() function.