declare

i integer;

v_rowid rowid;

cursor cur is

select *

from countries;

begin

execute immediate 'drop table tmp';

execute immediate 'create table tmp(row1 varchar2(50))';

for rec in cur loop

if rec.test like '%тест%' then

update countries c

set c.test = 'new test'

where c.country_id = rec.country_id

returning rowid into v_rowid;

insert into tmp values(v_rowid);

end if;

end loop;

execute immediate 'commit';

exception

when others

then

NULL;

end;