** Oracle数据库中判断字符串是否为全数字的函数 ** CREATE OR REPLACE FUNCTION is_number (parmin VARCHAR2) RETURN NUMBER IS val NUMBER; BEGIN val := TO_NUMBER (NVL (parmin, ‘a’)); RETURN 1; EXCEPTION WHEN OTHERS THEN RETURN 0; END;