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>