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 insert into a NUMBER column. How to resolve Oracle error ORA-01722 invalid number error Tagged on: ora-01722 oracle 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 → You May Also Like How to change the Oracle 8i Charset How to perform case insensitive searches How to find data that was entered yesterday Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Math Captcha − one = five