Write example for loop? in oracle
Example 1: for loop in oracle
DECLARE
count number(2) := 10;
BEGIN
FOR count in 10..20 (FOR count in REVERSE 10..20)
LOOP
dbms_output.put_line("COUNT : " || count);
END LOOP;
END;
-- FOR count in 10..20
-- it will print value from 10 to 20
-- FOR count in REVERSE 10..20
-- it will print value from 20 to 10
Example 2: 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;