Oracle中格式化数值(eg:保留两位小数) select trim(to_char(fee,'99999999999999.99')) from Htgl_Pact_Apply; select trim(to_char(fee,'00000000000000.00')) from Htgl_Pact_Apply;