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 create running totals with SQL

How to return errors when converting floating point numbers into number types

How to Find Years of Service of Employee

Leave a Reply

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

eighty − seventy four =