Oracle 替换回车和换行

发布时间 2023-10-12 19:30:20作者: 网络来者

 

 

--替换回车和换行

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, '"', '');