pl sql open cursor loop example

Example 1: for cursor plsql

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

Example 2: pl sql for each loop

FOR record IN cursor_name
LOOP
    process_record_statements;
END LOOP;