A bozo's blog
Friday, September 13, 2013
Oracle: Test whether string is numeric
1
LENGTH(TRIM(TRANSLATE(string1,
' +-.0123456789'
,
' '
))) IS NULL
See
http://www.techonthenet.com/oracle/questions/isnumeric.php
Newer Post
Older Post
Home
