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),'')