Oracle特殊字符转换:
select '特殊字符前边的字符'||chr(ascii('&'))||'特殊字符后边的字符' from dual;
查询结果:特殊字符前边的字符&特殊字符后边的字符
一、特殊字符 &
1、解决方法:
Set define off select * from ct_cuinfo where trim(vc2cuname)='Wharf T&T Limited' set define ON
2、解决方法:
select * from ct_cuinfo where trim(vc2cuname)='Wharf T'||chr(38)||'T Limited'