oracle中如何取消列值中的空格

2025-02-28 13:55:42
推荐回答(4个)
回答1:

update a set c=replace(c,' ');
两个单引号中间有个空格,它会把c列中存在的所有空格都删掉,慎用

回答2:

select trim(replace(col1,'\t','')) from tab1

回答3:

select replace(C,' ','') from A;

回答4:

select REPLACE( '测试 TEST', ' ', '') AS col from dual;