格式化显示数字,显示两位小数: select decode(salary,0,'0.00',(to_char(round(salary,2),'fm99999999999999.00'))) from can_do;