![oracle表中某个字段含有字符回车、空格的手动修改方式 oracle表中某个字段含有字符回车、空格的手动修改方式](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
select t.*, t.rowid from TB_SD_STANDARD_CHOOSE_ADVISE t where t.id =323900000
update TB_SD_STANDARD_CHOOSE_ADVISE t set t.standardName=replace(t.standardName,chr(13),'去除了回车') where t.id=323900000
update TB_SD_STANDARD_CHOOSE_ADVISE t set t.standardName=replace(t.standardName,chr(10),'去除了空格') where t.id=323900000