Oracle 数字转为字符串 to_char() 有大用 有大大用

格式：TO_CHAR(number,'format_model')

9 -->Represents a number

0 --> Forces a zero to be displayed

.  -->Prints a decimal point

, --> Prints a comma as a thousands indicator

select to_char(6000,'99,999.00') from dual;

6,000.00

select to_char(6000,'00,000.00') from dual;

06,000.00

来自 https://www.cnblogs.com/jycjy/p/11421764.html