select *
from (select 'abcdef' aa from dual
union all
select 'abc这是什么de' aa from dual)
where aa <> CONVERT(aa, 'US7ASCII', 'ZHS16GBK');
aa
--------
abc这是什么de
select *
from (select 'abcdef' aa from dual
union all
select 'abc这是什么de' aa from dual)
where aa <> CONVERT(aa, 'US7ASCII', 'ZHS16GBK');
aa
--------
abc这是什么de
转载于:https://www.cnblogs.com/jofy2004/archive/2011/01/30/1947849.html