将字符转成数字型

--将字符转换成数字--
CREATE OR REPLACE function CharToNumber(strNumber varchar2) RETURN NUMBER
IS
BEGIN
       RETURN (to_number(strNumber));
EXCEPTION
       WHEN others THEN
       RETURN (0);
END ;
/ 
--调用--
SELECT CharToNumber(HHH) FROM bdlly.T10_XZMD;