for loop in oracle sql query code example

Example 1: for plsql

FOR contatore IN lower bound..upper bound
LOOP 
	...
END LOOP;

Example 2: for select oracle

FOR <Loop_index> IN (<Select_statement>)
LOOP

    <Executable_statements>;

END LOOP [<Loop_index>];

Example 3: pl sql for each loop

FOR record IN cursor_name
LOOP
    process_record_statements;
END LOOP;