CODE EXAMPLE FOR SQL

oracle check numeric

SELECT CASE
           WHEN trim(translate(col1, '0123456789-,.', ' ')) IS NULL
               THEN 'numeric'
           ELSE 'other'
           END
FROM table_name;