游标法 批量修改多张表数据

游标法

declare
  v_sql varchar2(1000);
  v_table_name varchar2(50);
  cursor c1 is select table_name from 表名称 where 条件 ;
  begin
    open c1;
      loop
        fetch c1 into v_table_name;
        exit when c1%notfound;
      v_sql:='update' || v_table_name || ' set as_of_dt = to_date(''2020-07-31'',''yyyy-mm-dd'')';
      execute immediate v_sql;
      end loop;
    close c1;
  end;