都是数字?而且在一个值中的数字不会有重复吧?比如说a1为12334,这样就比较混乱了with tt as (select '12345' a,'45678' b from dual union all select '12435','785' from dual union all select '12','45' from dual)select a.a,a.b,(length(a.a||a.b)-count(b.rn))c from (select tt.*,rownum rn from tt) a, (select rownum-1 rn from dual connect by rownum<=10)b where instr(a.a||a.b,b.rn)>0 group by a.a,a.b,a.rn
union all select '12435','785' from dual
union all select '12','45' from dual)select a.a,a.b,(length(a.a||a.b)-count(b.rn))c
from (select tt.*,rownum rn from tt) a,
(select rownum-1 rn from dual
connect by rownum<=10)b
where instr(a.a||a.b,b.rn)>0
group by a.a,a.b,a.rn