Invalid number
How to resolve Oracle error ORA-01722 invalid number error
Find the number in error when you get an ORA-01722 invalid number error. select from where trim(translate(, ‘0123456789’, ‘ ‘)) IS NOT NULL This should return the fields that cannot be converted using TO_NUMBER or where text type data won’t