oracle for loop example
Example 1: oracle for loop
DECLARE
i NUMBER;
BEGIN
FOR i IN 1..5
LOOP
dbms_output.PUT_LINE('i value : ' || i);
END LOOP;
END;
Example 2: for plsql
FOR contatore IN lower bound..upper bound
LOOP
...
END LOOP;
Example 3: for loop oracle
-- FOR LOOP --------------
FOR loop_counter IN [REVERSE] lowest_number..highest_number
LOOP
{...statements...}
END LOOP;
-- FOR LOOP (MODERN) --------------
FOR record_index in cursor_name
LOOP
{...statements...}
END LOOP;
-- CURSOR LOOP (OLD STYLE) --------------
OPEN c_customers;
LOOP
FETCH c_customers into c_rowtype_var;
EXIT WHEN c_customers%notfound;
{...statements...};
END LOOP;