oracle 怎么确定一个字符串中数字的个数？

如一个字符串:ABCE34ER9,
用sql语句，我怎么去知道有多少个数字呢？（上面例子3个）


非常感谢！

---

SQL code:
select count(1)
from
(
select ascii(substr('ABCE34ER9',rownum,1)) a
from dual connect by rownum<=length('ABCE34ER9')
) where a between 48 and 57

--result:
3

---

SQL code:
考虑通用,写了一函数:

--FUNCTION:
/*
功能:判断字符串中数字个数
作者:cosio
时间: 2009-10-15
*/
CREATE OR REPLACE FUNCTION fun_test(a IN varchar)
RETURN NUMBER
IS
b NUMBER;
BEGIN
SELECT COUNT(*) INTO b
from
(SELECT ascii(substr(a,rownum,1)) a
from dual CONNECT BY rownum<=length(a))
WHERE a BETWEEN 48 AND 57;
RETURN(b);
End;

--TEST DATA:
with temp
as
(
select '1231aasb' t from dual
union all
select 'dasf131412341' from dual
)
select fun_test(t) from temp;

--RESULT:
4
9

---

在函数里写个for循环，遍历每个字符，跟'0'和'1'比较，效率会更高吧

---

说错了，是'0'和'9'

---

SQL code:
select length('luoyoumou11luo2093lllieoje') "字串长度",
length(translate('luoyoumou11luo2093lllieoje','0123456789','