Oracle去掉特殊字符

/*LYXXB(陵园信息表)
lymc(甲方),dz(通信地址),dh(联系电话)
*/
SELECT lymc,dz,dh FROM lyxxb
/*去掉回车(\b)*/
update lyxxb set dz=replace(dz,chr(13),'')
/*去掉换行(\n)*/
update lyxxb set dz=replace(dz,chr(10),'')
/*去掉回车(\b)*/
update lyxxb set dh=replace(dh,chr(13),'')
/*去掉换行(\n)*/
update lyxxb set dh=replace(dh,chr(10),'')

 

 

转载于:https://www.cnblogs.com/siyunianhua/p/3359217.html