Oracle 替换回车和换行

 

 

--替换回车和换行

update dc_group_parameter t

set t.description = replace(replace(t.description, chr(10), ''), chr(13), '')

where t.description <> replace(replace(t.description, chr(10), ''), chr(13), '');

--替换双引号

update dc_group_parameter t set t.description = replace(t.description, '"', '')

where t.description <> replace(t.description, '"', '');

 

update dc_group_parameter t

set t.prompt = replace(replace(t.prompt, chr(10), ''), chr(13), '')

where t.prompt <> replace(replace(t.prompt, chr(10), ''), chr(13), '');

 

 

update dc_group_parameter t set t.prompt = replace(t.prompt, '"', '') where t.prompt <> replace(t.prompt, '"', '');