LOOP « Cursor « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Cursor
  3. LOOP
25.5.LOOP
25.5.1.A loop is required is to read each row in cursor returned
25.5.2.Use For loop to output data in a PL/SQL table of cursor
25.5.3.Placing cursors in nested loops
25.5.4.Exit a LOOP when cursor%NOTFOUND
25.5.5.LOOP..END LOOP Cursor Loop
25.5.6.WHILE..LOOP Cursor Loop
25.5.7.Cursor FOR Loop
25.5.8.Loop till exit when cursorName%notfound
25.5.9.for data in ( select * from tableName )








25.5.10.while cursorName%found, loop