两个简单的循环

1.

create or replace procedure pro_test_01 is
begin
for aa in (select object_name from test_01)
loop
insert into test_02 values (aa.object_name);
end loop;
end;

2.

create or replace procedure pro_test_02 is
begin
declare
cursor aa is
select object_name from test_01;
begin
for ss in aa loop
begin
insert into test_02 values (ss.object_name);
commit;
end;
end loop;
end;
end;