Skip to content
Advertisement

ORA-01722: invalid number – Everything seems a digit

I have the below query:

However, when I execute it, the below error appears:

But, when trying to find what was the entry in col2 that was causing issues, I get no results:

Aby hints on how to keep searching for the col2 culprit will be hugely appreciated.

Advertisement

Answer

This expression is not going to find mixed digits and non-digits:

That is 'AAA1AAA' will match because it has a digit.

Try checking that everything is a digit:

Or that there are no non-digits:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement