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