去除换行 update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(10),''); 去掉回车 update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(13),''); 去掉空格 update zhzl_address t set t.add_administration_num=trim(t.add_administration_num); ----------------------------- 1、回车换行符 chr(10)是换行符， chr(13)是回车， 增加换行符 select ' update ' || table_name || ' set VALID_STATE =''0A'';'||chr(13)||' commit;' from user_tables
删除换行符 select id,replace(content,to_char(chr(13))||to_char(chr(10)),'_r_n') from fact_content order by content;
