Mega Code Archive

Use numformat to control the number format

SQL> SQL> create table t( my_column number ); Table created. SQL> SQL> insert into t values ( 1234567890 ); 1 row created. SQL> insert into t values ( 12345678901 ); 1 row created. SQL> insert into t values ( 12345678901234567890 ); 1 row created. SQL> SQL> select * from t; MY_COLUMN ---------- 1234567890 1.2346E+10 1.2346E+19 3 rows selected. SQL> SQL> set numformat 99999999999999999999.99999999999999 SQL> / MY_COLUMN ------------------------------------ 1234567890.00000000000000 12345678901.00000000000000 12345678901234567890.00000000000000 3 rows selected. SQL> select * from t; MY_COLUMN ------------------------------------ 1234567890.00000000000000 12345678901.00000000000000 12345678901234567890.00000000000000 3 rows selected. SQL> SQL> set numformat "" SQL> / MY_COLUMN ---------- 1234567890 1.2346E+10 1.2346E+19 3 rows selected. SQL> select * from t; MY_COLUMN ---------- 1234567890 1.2346E+10 1.2346E+19 3 rows selected. SQL> SQL> drop table t; Table dropped.