oracle stored procedure cursor while loop 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>];