Oracle去掉空格

–去掉左边空格
update tablename set columnname=ltrim(columnname);
–去掉右边空格
update tablename set columnname=rtrim(columnname);
–去掉两边空格
update tablename set columnname=trim(columnname);