Hi
I am using Oracle 12.1.2 and looking to find values in a column that contain garbled characters/symbols
For example below are some values
create table t1 (txt varchar2(200));
insert into t1 values('ROME ÃRGERE DICH NIYT');
insert into t1 values('XYZ TEAM - + THAT’S YOU!');
insert into t1 values(' 2022 - LTD FRANÇAIS + 2 XYZ');
insert into t1 values('EEÉUSSIR: ABC DE LA YYYY');
insert into t1 values('2000 - INCLUYE CANCIONES ESPAÑOLAS');
insert into t1 values('YYYY CAFÉ');
insert into t1 values('1999 - ÉFFFF CAT 2 ÉTOILES');
insert into t1 values('TRÃœBERBROOK');
insert into t1 values('ABC: GDI’S CUT');
insert into t1 values('ABC LTD');
insert into t1 values('SCS + PLC');
insert into t1 values('XYZ'S & PLC');
insert into t1 values('YYY: XD LTD');
insert into t1 values('EEE - PLC');
insert into t1 values('III/KKK LTD');
insert into t1 values('LEVÁNATE PLC');
The query should return the following fields that have symbols
ROME ÄRGERE DICH NIYT
XYZ TEAM - + THAT’S YOU!
2022 - LTD FRANÇAIS + 2 XYZ
EEÉUSSIR: ABC DE LA YYYY
2000 - INCLUYE CANCIONES ESPAÑOLAS
YYYY CAFÉ
1999 - ÉFFFF CAT 2 ÉTOILES
TRÃœBERBROOK
ABC: GDI’S CUT
Is there any expression that will help identify those columns?