User Defined IsNumeric Function in PL/SQL
Short and sweet. Accept a varchar input parameter, try to convert it to a number. If the conversion fails for any reason, return FALSE, else, return TRUE.
CREATE OR REPLACE FUNCTION is_numeric ( p_data VARCHAR2 ) RETURN NUMBER IS v_number NUMBER; o_bool BOOLEAN := TRUE; BEGIN BEGIN v_number := p_data; EXCEPTION WHEN OTHERS THEN o_bool := FALSE; END; RETURN o_bool; END isnumber;
Recent Buzz