oracle loop through cursor code example
Example 1: for select oracle
FOR <Loop_index> IN (<Select_statement>)
LOOP
<Executable_statements>;
END LOOP [<Loop_index>];
Example 2: pl sql for each loop
FOR record IN cursor_name
LOOP
process_record_statements;
END LOOP;