RosettaCodeData/Task/Determine-if-a-string-is-nu.../PL-SQL/determine-if-a-string-is-nu...

12 lines
182 B
SQL

FUNCTION IsNumeric( value IN VARCHAR2 )
RETURN BOOLEAN
IS
help NUMBER;
BEGIN
help := to_number( value );
return( TRUE );
EXCEPTION
WHEN others THEN
return( FALSE );
END;