Oracle PL/SQL Programming: A Developer's Workbook

Expert

2-22.	This block uses a FOR loop that has one way in, but two ways out: FOR yearnum IN 1 .. years_in LOOP show_profits (yearnum); IF yearnum > 10 THEN EXIT; END IF; END LOOP; Which of the following loops provides a revised implementation of that FOR loop that has just one way in and one way out and that is logically equivalent to the original? FOR yearnum IN 1 .. 11 LOOP show_profits (yearnum); END LOOP; FOR yearnum IN 1 .. 10 LOOP show_profits (yearnum); END LOOP; FOR yearnum IN 1 .. LEAST (years_in, 11) LOOP show_profits (yearnum); END LOOP; FOR yearnum IN 1 .. LEAST (years_in, 11) LOOP show_profits (yearnum); EXIT WHEN yearnum > years_in; END LOOP;
2-23.	How many times does the following WHILE loop execute? DECLARE end_of_analysis BOOLEAN := FALSE; CURSOR analysis_cursor IS SELECT ...; /* Something that returns a few rows. */ analysis_rec analysis_cursor%ROWTYPE; next_analysis_step NUMBER; PROCEDURE get_next_record (step_out OUT NUMBER) IS BEGIN FETCH analysis_cursor INTO analysis_rec; IF analysis_rec.status = 'FINAL' THEN step_out := 1; ELSE step_out := 0; END IF; END; BEGIN OPEN analysis_cursor; WHILE NOT end_of_analysis LOOP get_next_record (next_analysis_step); IF analysis_cursor%NOTFOUND AND next_analysis_step IS NULL THEN end_of_analysis := TRUE; ELSE perform_analysis; END IF; END LOOP; END;
2-24.	Select the type of loop (FOR, WHILE, simple) appropriate to implement the following requirement: set the status of each company to closed for each company whose ID is defined as a ...