sql - Search for data that is not english text

Question

in a nutshell: I need to be able to search within Oracle DB inside a certain column, for all occurrences that are not English text, or contain signs like -^ etc'. (capital and non-capital are ok) in general, I'm looking to find all occurrences of other languages, Korean Spanish etc'.

ID    NAME      DATE
1     TEST      2018-12-02 11:09:05
2     TE-ST     2018-12-02 11:09:05
3     测试       2018-12-02 11:09:05

i expect the query to find only row #3.

Answer 1

with test as
(
select 'hello good morning' txt from dual 
union select 'Bad weather' from dual
union select '测试 ' from dual
    union select 'L''Inhêrit ' from dual
    union select '???' from dual
)
select *
from test
where txt != asciistr( txt )