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 drop a column from a table using Oracle 8i

How to remove leading zeros from a string using SQL

How to get time from a date

Leave a Reply

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

eighty nine − 80 =