RosettaCodeData/Task/Determine-if-a-string-is-numeric/PL-SQL/determine-if-a-string-is-numeric-1.sql

12 lines
182 B
MySQL
Raw Permalink Normal View History

2013-04-10 22:43:41 -07:00
FUNCTION IsNumeric( value IN VARCHAR2 )
RETURN BOOLEAN
IS
help NUMBER;
BEGIN
help := to_number( value );
return( TRUE );
EXCEPTION
WHEN others THEN
return( FALSE );
END;