--loops

--exit_statement.sql 
SET SERVEROUTPUT ON;
DECLARE
   v_counter NUMBER := 0;
BEGIN
   LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
      EXIT;
   END LOOP;
END;
/

--*****************************************************************
--while_loop1.sql 
SET SERVEROUTPUT ON;
DECLARE
   v_counter NUMBER := 5;
BEGIN
   WHILE v_counter < 5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
      v_counter := v_counter - 1;
   END LOOP;
END;
/

--*******************************************************************
--while_loop2.sql 
SET SERVEROUTPUT ON;
DECLARE
   v_counter NUMBER := 1;
BEGIN
   WHILE v_counter < 5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
      v_counter := v_counter - 1;
   END LOOP;
END;
/

--************************************************************************
while_loop3.sql 
SET SERVEROUTPUT ON;
DECLARE
   v_counter NUMBER := 1;
BEGIN
   WHILE v_counter <= 5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
      EXIT WHEN v_counter = 2;
      v_counter := v_counter + 1;
   END LOOP;
END;
/

--*****************************************************************************

--for_loop1.sql 
SET SERVEROUTPUT ON;
BEGIN
   FOR v_counter IN 1..5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
   END LOOP;
END;
/
--**********************************************************************************
for_loop2.sql 
SET SERVEROUTPUT ON;
BEGIN
   FOR v_counter IN 1..5 LOOP
      v_counter := v_counter + 1;
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
   END LOOP;
END;
/

--****************************************************************
for_loop3.sql 
SET SERVEROUTPUT ON;
BEGIN
   FOR v_counter IN REVERSE 1..5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
   END LOOP;
END;
/

--**************************************************************
--for_loop4.sql 
SET SERVEROUTPUT ON;
BEGIN
   FOR v_counter IN 1..5 LOOP
      DBMS_OUTPUT.PUT_LINE('v_counter = '||v_counter);
      EXIT WHEN v_counter = 3;
   END LOOP;
END;
/