oracle修改多张表的字段值

declare
v_sql varchar2(10000);
v_table_name varchar(100);
cursor c1 is select table_name from user_tables where TABLE_NAME like 'GE_%';
begin 
  open  c1;
  loop
    fetch c1 into v_table_name;
    exit when c1%notfound;
    v_sql:='Update '||v_table_name||' set DEPT_ID= ''CNPC.PetroChina.TLM..HYGS''';
    execute immediate v_sql;
  end loop;
  close c1;
end;