G ghou Member Jul 15, 2003 #1 SQL> select 15/566347 from dual; 15/566347 --------- 2.6485529 SQL> I have not found anywhere we can set the format. Thanks,
SQL> select 15/566347 from dual; 15/566347 --------- 2.6485529 SQL> I have not found anywhere we can set the format. Thanks,
Marco Kalter Administrator Staff member Jul 15, 2003 #1 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 Click to expand... ------------------ Marco Kalter Allround Automations [This message has been edited by mkalter (edited 15 July 2003).]
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 Click to expand... ------------------ Marco Kalter Allround Automations [This message has been edited by mkalter (edited 15 July 2003).]