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:     

You May Also Like

How to limit the number of objects created by an Oracle user

How to find out which Oracle version is installed on Unix

How to find the exact difference between dates

Leave a Reply

Your email address will not be published. Required fields are marked *

eighty one − = seventy seven