declare
v_sql varchar2(1000);
begin
for tabname in(select a from A) loop
v_sql :='update '||tabname.a||' set a=trim(a)';
execute immediate v_sql;
end loop;
end;
/
v_sql varchar2(1000);
begin
for tabname in(select a from A) loop
v_sql :='update '||tabname.a||' set a=trim(a)';
execute immediate v_sql;
end loop;
end;
/
declare
v_sql varchar2(1000);
begin
for tabname in(select a from A) loop
v_sql :='update '||tabname||' set a=replace(a,' ')';
execute immediate v_sql;
end loop;
end;
declare
v_sql varchar2(1000);
begin
for tabname in(select a from A) loop
v_sql :='update '||tabname||' set a=regexp_replace(a,''\s'','''')';
execute immediate v_sql;
end loop;
end;
v_sql varchar2(1000);
begin
for tabname in(select a from A) loop
v_sql :='update '||tabname.a||' set a=regexp_replace(a,''\s'','''')';
execute immediate v_sql;
end loop;
end;