数值精度展示问题

SQL> SELECT to_char(1890.55, '$0G000D00') FROM dual;
TO_CHAR(1890.55,'$0G000D00')
----------------------------
 $1,890.55
SQL> SELECT to_char(1890.55, '$9,999V99') FROM dual;
TO_CHAR(1890.55,'$9,999V99')
----------------------------
 $1,89055
SQL> SELECT to_char(1890.55, '$99,999D99') FROM dual;
SELECT to_char(1890.55, '$99,999D99') FROM dual
ORA-01481: invalid number format model
SQL> SELECT to_char(1890.55, '$99G999D00') FROM dual;
TO_CHAR(1890.55,'$99G999D00')
-----------------------------
  $1,890.55
SQL> SELECT to_char(1890.55, '$99G999D99') FROM dual;
TO_CHAR(1890.55,'$99G999D99')
-----------------------------
  $1,890.55

G表示分隔符

D表示小数点

V表示乘以10的N次方，V后面跟着几位就乘以10的几次方

0表示补齐的位数

SQL> SELECT to_char(1890.55, '$0G000D0000000') FROM dual;
TO_CHAR(1890.55,'$0G000D000000
------------------------------
 $1,890.5500000

--关于数值精度的展示方法：

SQL> /*
  2    FM 剔除空格
  3    如下例子表示：
  4    小数点后最少保留两位，最多4位，小数点前最少保留一位，做多保留4位
  5  */
  6  SELECT to_char(10.1, 'FM9990.0099') FROM dual;
TO_CHAR(10.1,'FM9990.0099')
---------------------------
10.10