Find the number in error when you get an ORA-01722 invalid number error.
select
from
This should return the fields that cannot be converted using TO_NUMBER or where text type data won’t insert into a NUMBER column.
How to resolve Oracle error ORA-01722 invalid number error
- How to find out which Oracle version is installed on Unix
- How to check users are not trying to change other users passwords