循环操作

Declare
i int:=0;
Begin
while i<5 loop
  i:=i+1;
  dbms_output.put_line(i);
end loop;

End;

----------------------------------------------------------------------------------------------------------------------------------------

 

Declare
  --v varchar(100);
Begin
 For I In 1..10 Loop
  Dbms_Output.Put_Line(sysdate-i);
  commit;
 end loop;

End;

 

----------------------------------------------------------------------------------------------------------------------------------

Declare
  --v varchar(100);
Begin
 For I In (select * from ct_cuinfo) Loop
  Dbms_Output.Put_Line(i.numcuguid);
  commit;
 end loop;

End;