using a cursor for loop code example
Example: for cursor plsql
FOR record_name IN cursor_name
LOOP
statement1;
statement2;
. . .
END LOOP;
FOR record_name IN cursor_name
LOOP
statement1;
statement2;
. . .
END LOOP;