CURSOR FOR Loop « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. CURSOR FOR Loop
1.Create a cursor in for statement
2.The %FOUND, %NOTFOUND, and %ROWCOUNT cursor attributes can be used to guide a loop
3.A function that uses a CURSOR FOR Loop
4.Use 'for loop' to loop through the cursor
5.A subquery in the FROM clause of a cursor within a cursor FOR loop
6.Assign value from cursor to a table collection by index
7.Calculation based on cursor value
8.For each row in a cursor
9.Output value in cursor one by one




10.Simple Loop and fetch cursor
11.Use pl/sql, cursor and for loop to count table