两个简单的循环

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;