字符串转成数字
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;
字符串转成数字
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;