oracle实现数值型列值各位相加之和

求整型数值各位相加

SELECT SUM(NM) TOTAL
      FROM (SELECT SUBSTR(&innum, ROWNUM, 1) NM
            FROM DUAL CONNECT BY ROWNUM <= LENGTH(&innum))

 

 

求浮点型数值各位相加
SELECT SUM(TRANSLATE(NM, '0123456789'||NM, '0123456789')) from (
SELECT SUBSTR(12.134, ROWNUM, 1) NM
FROM DUAL CONNECT BY ROWNUM <= LENGTH(12.134));