To detect a record of non-numeric characters in a numeric character field

Recently, when you converted the original numeric character field to a number, the total error: Invalid number.

How to find out which records are non-numeric characters. It's a bit of a hassle. The following is a function translate with Oracle DB that can be found

1. Create a test table

Create Table Testchar (
Item_Number VARCHAR2 (20)
);

2. Insert Test Record manually

Insert into Testchar (item_number) VALUES (' 312 ');
Insert into Testchar (item_number) VALUES (' 312 ');
Insert into Testchar (item_number) VALUES (' 4412 ');
Insert into Testchar (item_number) VALUES (' 152 ');
Insert into Testchar (item_number) VALUES (' 162 ');
Insert into Testchar (item_number) VALUES (' 172 ');
Insert into Testchar (item_number) VALUES (' 142 ');
Insert into Testchar (item_number) VALUES (' 142 ');
Insert into Testchar (item_number) VALUES (' 112 ');
Insert into Testchar (item_number) VALUES (' 1d2 ');
Insert into Testchar (item_number) VALUES (' 152 ');
Insert into Testchar (item_number) VALUES (' 125 ');
Insert into Testchar (item_number) VALUES (' 162 ');
Insert into Testchar (item_number) VALUES (' 712 ');
Insert into Testchar (item_number) VALUES (' A712 ');
Commit

3. Magical Oracle Built-in function translate to find out the records of Non-numeric characters

Select Trim (Translate (RTRIM (LTRIM (Item_Number)), ' #0123456789 ', ' # ')
From Testchar
Where Trim (Translate (RTRIM (LTRIM (Item_Number)), ' #0123456789 ', ' # ') is not null;