去掉表中字段空的空格或换行符

1.查出含有空格或换行符的行

select id from osm_t_arc_contacts x where instr(x.address, chr(10) )> 0 or instr(x.address,chr(13))>0;

2.去掉
update osm_t_arc_contacts set address = replace(address, chr(10),'')
where id= xxxx;

转载于:https://www.cnblogs.com/steel-chen/p/7069812.html