1 获取ascii码
select ascii('特殊字符') from dual
2 替换
update table set testfield= replace(testfield,chr(ascii码),'') where 查询条件
1 获取ascii码
select ascii('特殊字符') from dual
2 替换
update table set testfield= replace(testfield,chr(ascii码),'') where 查询条件
转载于:https://www.cnblogs.com/yzlsthl/p/8397839.html