Oracle中将小数转换成字符丢零.截取小数.除数为零解决法时间:2023-03-09 05:19:36 如下所示,前面少个0 SQL>select money from users where username ='LEI'; money --------- .3256 解决方法: SQL>select to_char(money ,'fm9999999990.00') from users where username ='LEI'; money --------- 0.3256