Oracle给大数值添加逗号的分位符形如:9,999,999,999

SELECT TO_CHAR(1231231123, '9,999,999,999') FROM dual
;

 1,231,231,123

SELECT TO_CHAR(1231231123, '9,999,99,9,999') FROM dual
;

 1,231,23,1,123

原文地址:https://www.cnblogs.com/YuyuanNo1/p/9176197.html