Oracle将数值转字符串,带两位小数
to_char()
语法:
to_char(处理的值 , '格式化的类型');
示例:
to_char('363','9,999.00');
如:select to_char('363','9,999.00') from dual;
输出: 363.00
to_char('2333.32','9,999.00');
如:select to_char('2333.32','9,999.00') from dual;
to_char(处理的值 , '格式化的类型');
如:select to_char('363','9,999.00') from dual;
如:select to_char('2333.32','9,999.00') from dual;