for loop in sql oracle code example
Example 1: for plsql
FOR contatore IN lower bound..upper bound
LOOP
...
END LOOP;
Example 2: pl sql for each loop
FOR record IN cursor_name
LOOP
process_record_statements;
END LOOP;
FOR contatore IN lower bound..upper bound
LOOP
...
END LOOP;
FOR record IN cursor_name
LOOP
process_record_statements;
END LOOP;