While loop with complex conditions
SQL> SQL> SQL> --While loop with conditions SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE 2 counter NUMBER(2):= 1; 3 counter2 NUMBER(2):= 1; 4 BEGIN 5 WHILE counter <= 12 AND counter2 <= 14 LOOP 6 counter := counter + 1; 7 counter2 := counter2 + 1; 8 END LOOP; 9 DBMS_OUTPUT.PUT_LINE('counter2:'||counter2); 10 DBMS_OUTPUT.PUT_LINE('counter:'||counter); 11 END; 12 / counter2:13 counter:13 PL/SQL procedure successfully completed. SQL> SQL>