This is a basic oracle procedure with cursor:

DECLARE
   CURSOR my_cursor IS
      SELECT * FROM table_a LEFT JOIN table_b ON a.x = b.x 
BEGIN
     FOR things IN my_cursor
        LOOP
             -- do stuff
        END LOOP
        COMMIT;
END;