Oracle去掉特殊字符

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