Loop « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Loop
1.Use EXIT WHEN to exit a loop
2.Empty Loop statement
3.unconstrained loop
4.Loop with label
5.LOOP..END LOOP, Cursor Loop
6.Insert a row into MyTable with the current value of the loop counter.
7.An anonymous block demonstrates a guard on exit simple loop