Hi Tom,

I've below code where i need to update different table with status to null.

declare
type v_table_name is table of varchar2(100);
p_tab v_table_name;
pv_tab v_table_name;
v_sql varchar2(100);
v_var varchar2(100);

TYPE NameList IS TABLE OF VARCHAR2(15);
enames NameList;
begin
select table_name bulk collect
into p_tab
from user_tables
where table_name like 'MOR_%';
for i in 1 .. p_tab.count loop
dbms_output.put_line(p_tab(i));
end loop;

/*for i in 1 .. p_tab.count
loop
execute immediate 'update ' || p_tab(i) || ' set MONEY = NULL';
end loop;
commit;*/
forall i in p_tab.first .. p_tab.last
execute immediate 'update || p_tab(i) || ' set MONEY = NULL' using p_tab(i);
commit;
end;

Please advise how to perform Bulk Updates on All MOR% tables.

Thanks
Dnesh

  for i in 1 .. p_tab.count
  loop
    dbms_output.put_line ( p_tab ( i ) ) ;
  end loop;