--去除换行
update customertriad t set t.customercname=replace(t.customercname,chr(10),'') where t.customercode='20171117103742877';
--去掉回车
update customertriad t set t.customercname=replace(t.customercname,chr(13),'') where t.customercode='20171117103742877';
--去掉空格
update customertriad t set t.customercname=trim(t.customercname) where t.customercode='20171117103742877';
oracle去掉换行符、空格符、回车符
最新推荐文章于 2024-04-19 16:30:39 发布