Question

oracle:to_char(0,'fm99999999990.99')，结果是“0.”，能把零后面的点“.”去掉么？？

Answer 1

select trim('.' from to_char(0,'fm99999999990.99')) from dual;