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