number output is cut-off in Command Window

ghou

Member
SQL> select 15/566347 from dual;

15/566347
---------
2.6485529

SQL>

I have not found anywhere we can set the format.

Thanks,
 
The SET NUMWIDTH command should do the trick:
Code:
SQL> select 15/566347 from dual;

 15/566347
----------
2.64855291

SQL> set numwidth 20
SQL> select 15/566347 from dual;

           15/566347
--------------------
 2.64855291897017E-5

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 15 July 2003).]
 
Back
Top