天天看点

oracle去除字符串中间的空格

update AC01 A

set A.AAC003 = REGEXP_REPLACE(A.AAC003, '( ){1,}', '')

WHERE A.AAC002 IN (SELECT AAC002 FROM ac01_temp_);

转载于:https://www.cnblogs.com/Sunnor/p/5667038.html