oracle列中带有换行等特殊符号查找方式

 

查询某列是否有空行

select comments from s_org_ext_x t1 where  instr(t1.comments,chr(13))>0 or  instr(t1.comments,chr(10))>0

更新

 update s_org_ext_x t1 set comments=replace(replace(comments,chr(10),''),chr(13),'')

 where  instr(t1.comments,chr(13))>0 or  instr(t1.comments,chr(10))>0