for loop in select query oracle code example

Example: for select oracle

FOR <Loop_index> IN (<Select_statement>)
LOOP

    <Executable_statements>;

END LOOP [<Loop_index>];