Oracle更新替换换行和空格

update progress_report_state t set t.rpt_state=replace(t.rpt_state,chr(38)||'amp;','') where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));

update progress_report_state t set t.rpt_state=replace(t.rpt_state,chr(38)||'#13;',chr(13)) where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));

update progress_report_state t set t.rpt_state=replace(t.rpt_state,'#13;',chr(13)) where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));

update progress_report_state t set t.rpt_state=replace(t.rpt_state,chr(38)||'#10;',chr(10)) where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));

update progress_report_state t set t.rpt_state=replace(t.rpt_state,'#10;',chr(10)) where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));
create table progress_report_state_20190329 as select * from progress_report_state t
where t.rpt_code in(
select t.rpt_code from progress_report_state t left join progress_report p on t.rpt_code=p.rpt_code where p.end_date=to_date('2018-12-31','yyyy-mm-dd'));

select t.* from progress_report_state_20190329 t;