TO_CHAR(T2.STOCK_AMOUNT,'fm99,999,999,990.00') 0会格式为0.00
TO_CHAR(T2.STOCK_AMOUNT,'fm99,999,999,999.00') 0会格式为 .00
fm表示去掉前导空格。
TO_CHAR(T2.STOCK_AMOUNT,'fm99,999,999,990.00') 0会格式为0.00
TO_CHAR(T2.STOCK_AMOUNT,'fm99,999,999,999.00') 0会格式为 .00
fm表示去掉前导空格。