Oracle: Test whether string is numeric

LENGTH(TRIM(TRANSLATE(string1, ' +-.0123456789', ' '))) IS NULL

See http://www.techonthenet.com/oracle/questions/isnumeric.php