oracle 字符串转数字

字符串转成数字

CREATE OR REPLACE FUNCTION char_to_number( C VARCHAR2)
RETURN FLOAT
IS
N number;
BEGIN
   BEGIN
      N :=to_number(C);
      RETURN N;
   EXCEPTION WHEN OTHERS THEN
   RETURN null;
   END;

END;