command window truncates numbers

[yonderboi]

Sometimes command window truncates numbers. Here's an example:

SQL> select 100/100000000 from dual;

100/100000000
-------------
         1E-6

SQL> select 100/123456789 from dual;

100/123456789
-------------
8.10000007371

Using e-notation, it should've been "8.100E-07" of course

 

[Marco Kalter]

You can use the SET NUMWIDTH 20 command to increase the display width of number columns.