update a set c=replace(c,' ');两个单引号中间有个空格,它会把c列中存在的所有空格都删掉,慎用
select trim(replace(col1,'\t','')) from tab1
select replace(C,' ','') from A;
select REPLACE( '测试 TEST', ' ', '') AS col from dual;