for select oracle

        
            
        
     FOR record IN cursor_name
LOOP
    process_record_statements;
END LOOP;

FOR <Loop_index> IN (<Select_statement>)
LOOP

    <Executable_statements>;

END LOOP [<Loop_index>];