SQL Query to check Numeric or Character

 SELECT 

    CASE  

    WHEN REGEXP_LIKE ('1A', '^\-?\d+(\.\d+)?$(E(\+|\-)\d+)?$')  THEN

        'Numeric'

    ELSE

        'Character'

    END

FROM DUAL;