Oracle Check IS NUMBER
转载:IS NUMBER - Oracle FAQ
Oracle doesn’t have a built-in IS_NUMERIC function to check is a value is numeric, but over the years people developed innovative alternatives. This page will discuss some of them:
# SQL solution
Pure SQL solutions usually use TRANSLATE or REGEXP_LIKE to identify numeric...
more...