declare
a number;
b number;
begin
for a in 1..10000 loop
b := a;
insert into t1 (id,name) values (a,b);
end loop;
end;
declare
n number;
begin
for m in 196..205 loop
update emp set sal=(select sal from emp as of timestamp to_timestamp('2017-09-27 13:40:19','yyyy-mm-dd hh24:mi:ss') where id=m) where id=m;
end loop;
end;
/
declare
n number;
begin
for m in 1..10000 loop
update emp set sal=(select sal from emp as of timestamp to_timestamp('2017-09-27 13:40:19','yyyy-mm-dd hh24:mi:ss') where id=m) where id=m;
end loop;
end;
/