ORACLE中科学计数法显示问题的解决
2019-03-19在sqlplus 中显示的是科学计数法，设定以下可以不用科学计数法显示：
1、
SQL> select to_number('1234567891234567') from dual;
TO_NUMBER('1234567891234567')
-----------------------------
1.234567891E+15
2、set numwidth 30
SQL> show sga
Total System Global Area 1.0021E+10 bytes
Fixed Size 2261848 bytes
Variable Size 1811942568 bytes
Database Buffers 8187281408 bytes
Redo Buffers 19894272 bytes
SQL> set numwidth 30
SQL> show sga
Total System Global Area 10021380096 bytes
Fixed Size 2261848 bytes
Variable Size 1811942568 bytes
Database Buffers 8187281408 bytes
Redo Buffers 19894272 bytes
SQL>