[sql] Finding rows that don't contain numeric data in Oracle

I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric data even though it is a varchar2 column. I need to find the records which don't contain numeric data (The to_number(col_name) function throws an error when I try to call it on this column).

This question is related to sql oracle varchar numeric varchar2

The answer is

I was thinking you could use a regexp_like condition and use the regular expression to find any non-numerics. I hope this might help?!

SELECT * FROM table_with_column_to_search WHERE REGEXP_LIKE(varchar_col_with_non_numerics, '[^0-9]+');

Similar questions with sql tag:

Similar questions with oracle tag:

Similar questions with varchar tag:

Similar questions with numeric tag:

Similar questions with varchar2 tag: