ТЕМА:

declare
type t_table is table of varchar2(1000) index by binary_integer;
loTable t_table;

i Number;

begin
loTable(1) := '1212-АДЛ';
loTable(2) := '12121-УКЛ';
loTable(3) := '121212'-УСП;

i:=0;
for i in loTable.first .. loTable.last loop
update table2 set table2.name='Test information' where table2.id=loTable(i);
commit;
end loop;

end;

declare 
type t_table is table of varchar2(1000) index by binary_integer;
loTable t_table;

i Number;

begin
loTable(1) := '1212-АДЛ';
loTable(2) := '12121-УКЛ';
loTable(3) := '121212-УСП';

i := loTable.first;
while i is not null 
loop
dbms_output.put_line(loTable(i));    
i := loTable.next(i);
end loop;
commit;
end;

update table2 set table2.name='Test information' where table2.id in ('1212-АДЛ', '12121-УКЛ', '121212'-УСП);