--查询'05011045'里0的个数
select length('05011045')-length(replace('05011045','0','')) FROM dual ------3
SELECT (lenGTH('13770-32129-37829-31158-4640')-lenGTH(replace('13770-32129-37829-31158-4640','-','')))/lenGTH('-')
from DUAL ----4
--查询'05011045'里0的个数
select length('05011045')-length(replace('05011045','0','')) FROM dual ------3
SELECT (lenGTH('13770-32129-37829-31158-4640')-lenGTH(replace('13770-32129-37829-31158-4640','-','')))/lenGTH('-')
from DUAL ----4