PL/SQL block loop cursor example

Example 1: for cursor plsql

FOR record_name IN cursor_name
LOOP 
	statement1; 
	statement2; 
	. . . 
END LOOP;

Example 2: for select oracle

FOR <Loop_index> IN (<Select_statement>)
LOOP

    <Executable_statements>;

END LOOP [<Loop_index>];