Oracle中如何将姓名中有空格的字段更新成没有空格的?

    1>新建临时表

2>

select * from grdk_sq_htxx where jkrxm='吴建广';---吴建广

update grdk_sq_htxx t set t.jkrxm = replace(jkrxm,' ','') where regexp_like(t.jkrxm,'[[:space:]]');

转载于:https://blog.51cto.com/11218855/2108243