Question: How can I see whether a string is
numeric? MySQL has an isnumeric function but Oracle does not
have anything to check if a string is numeric.
Answer: This
command will test whether a string value is numeric in
Oracle:
LENGTH(TRIM(TRANSLATE(, '
+-.0123456789', ' '))) is null