遍历

1.使用存储过程procedure

语法：for ... in ...

案例：

create or replace procedure test_procedure_job(operationid  varchar2)
is
v1 varchar2(10);
begin
   for v1 in
   (select a from testinsert group by a)
   loop
       insert into testinsert (a,b) values(v1.a,operationid);      
    
   end loop;
  
end test_procedure_job;