Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Loop through the Implicit Cursor

By: FYIcenter.com

(Continued from previous topic...)

How To Loop through Data Rows in the Implicit Curosr?

You use the FOR ... IN ... LOOP statement to loop through data rows in the implicit cursor as the following syntax:

  FOR row IN dml_statement LOOP
    (statement block with row.field)
  END LOOP; 

Here "row" is a local RECORD type variable with fields automatically defined to match the fields in the data rows resulted from the DML statement. Here is a good tutorial exercise on loop through data rows with the implicit cursor:

BEGIN                                                  
   FOR row IN (SELECT * FROM employees
       WHERE manager_id = 101) LOOP
     DBMS_OUTPUT.PUT_LINE('Name = ' || row.last_name); 
   END LOOP;                                           
END;                                                   
/                                                      
Name = Greenberg
Name = Whalen
Name = Mavris
Name = Baer
Name = Higgins

(Continued on next topic...)

  1. What Is a Cursor?
  2. How Many Types of Cursors Supported in PL/SQL?
  3. What Is the Implicit Cursor?
  4. How To Use Attributes of the Implicit Cursor?
  5. How To Loop through Data Rows in the Implicit Curosr?
  6. How To Define an Explicit Cursor?
  7. How To Open and Close an Explicit Cursor?
  8. How To Retrieve Data from an Explicit Cursor?
  9. How To Retrieve Data from a Cursor to a RECORD?
  10. How To Use FETCH Statement in a Loop?
  11. How To Use an Explicit Cursor without OPEN Statements?
  12. Can Multiple Cursors Being Opened at the Same Time?
  13. How To Pass a Parameter to a Cursor?
  14. What Is a Cursor Variable?
  15. How To Define a Cursor Variable?
  16. How To Open a Cursor Variable?
  17. How To Loop through a Cursor Variable?
  18. How To Pass a Cursor Variable to a Procedure?
  19. Why Cursor Variables Are Easier to Use than Cursors?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...