Oracle table problem

Recently encountered a strange Oracle problem:
There is a table in the Oracle database. When querying the column of the varchar2 type in the table, normal results are always not found. If you query other types of columns, normal results can be returned. The simplified example is as follows:
The ID column is of the number type.
The name column is of the varchar2 (10) type)
The data in the table is as follows: (1, '94 '), (2, '94'), (3, 'testname ')

Select * From testtable where id = 1 can return normal results
Select * From testtable where name = '94 'return No rows select
Select * From testtable where name = 'testname' can return normal results
The strange thing is that select * From testtable where name = 94 can return normal results.

In addition, the view associated with this table's varchar2 Column cannot return normal results.
Other tables in this database are queried normally.

I can't help but drop this table and create it again. It can work normally, but the customer does not allow me to do this.
And I want to know why.

Which of you can give me some advice? Thank you!