关于数值显示问题

Question

用格式'EEEE',例如：
SQL> SELECT TO_CHAR(123,'9.99EEEE') FROM DUAL;TO_CHAR(12
----------
  1.23E+02

Answer 1

使用to_char
to_char(你的数字,format)format 有很多种,你查查帮助

Answer 2

TO_CHAR(NUBER,格式串)
格式串可参见ORACLE文档

Answer 3

 number          'fmt'          Result 
-1234567890  9999999999S     '1234567890-'
 
0            99.99            ' .00'
 
+0.1         99.99            ' .10'
 
-0.2         99.99            ' -.20'
 
0            90.99            ' 0.00'
 
+0.1         90.99            ' 0.10'
 
-0.2         90.99            ' -0.20'
 
0            9999             ' 0'
 
1            9999             ' 1'
 
0            B9999            ' '
 
1            B9999            ' 1'
 
0            B90.99            ' '
 
+123.456     999.999           ' 123.456'
 
-123.456    999.999            '-123.456'
 
+123.456    FM999.009          '123.456'
 
+123.456    9.9EEEE           ' 1.2E+02'
 
+1E+123     9.9EEEE           ' 1.0E+123'
 
+123.456    FM9.9EEEE        '1.2E+02'
 
+123.45     FM999.009         '123.45'
 
+123.0      FM999.009          '123.00'
 
+123.45     L999.99            ' $123.45'
 
+123.45     FML999.99          '$123.45'
 
[phone]  9999999999S       '1234567890+'