去除換行 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;
