–换行或空格:
update tableName set columnName=replace(columnName, chr(13)||chr(10), ‘’)
–换行及空格:
update tableName set columnName=
replace(replace(columnName, chr(13), ‘’), chr(10), ‘’)
Oracle替换换行或空格
最新推荐文章于 2024-09-11 07:16:42 发布
–换行或空格:
update tableName set columnName=replace(columnName, chr(13)||chr(10), ‘’)
–换行及空格:
update tableName set columnName=
replace(replace(columnName, chr(13), ‘’), chr(10), ‘’)