Friday, September 13, 2013

Oracle: Test whether string is numeric

LENGTH(TRIM(TRANSLATE(string1, ' +-.0123456789', ' '))) IS NULL
See http://www.techonthenet.com/oracle/questions/isnumeric.php