create or replace
FUNCTION "ISNUMERIC" (str IN VARCHAR2)
RETURN NUMBER
IS
v_str FLOAT;
BEGIN
IF str IS NULL THEN
RETURN 0;
ELSE
BEGIN
SELECT TO_NUMBER (str) INTO v_str FROM DUAL;
EXCEPTION
WHEN INVALID_NUMBER THEN
RETURN 0;
END;
RETURN 1;
END IF;
END isnumeric;
oracle数据库判断是否是数字函数
最新推荐文章于 2021-04-08 09:57:41 发布