字符串上每位相加

〇〇

〇〇 发表于 2016-10-25 19:53
with t as(select 12345 a  from dual union all
select 678910 from dual)
select a,SUM(SUBSTR(a, LV ...

最原始的写法最方便

260600sz

with tb
as
(
SELECT '12345'a  FROM dual UNION ALL
SELECT '56789'a  FROM dual
)

select a,sum(substr(a,lv,1) )from tb,
(select level lv from dual connect by level<=100)val
where val.lv<=length(tb.a)
GROUP BY A

newkid

4楼方法最好，省得拆了重组，但是dbms_aw好像是个另外收费的组件。

wmxcn2000

oracle_cj 发表于 2016-10-25 13:59
或者
SELECT dbms_aw.eval_number(regexp_replace('12345', '(.)', '\1+') || '0') a
  FROM dual

赏了。

a10322495

只有我看不懂楼主的意思吗