如何实现小数点后面数据的追加零

 SELECT DECODE (  LENGTH ('100.02')
               - DECODE (INSTR (TO_CHAR ('100.02'), '.'),
                         0, LENGTH ('100.02'),
                         INSTR (TO_CHAR ('100.02'), '.')
                        ),
               1, CONCAT ('100.02', '0'),
               0, CONCAT ('100.02', '.00'),'100.02'
              )
  FROM DUAL;