cursor for loop with a select statement 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;