PL-SQL-Learning-Tutorial/SimpleLoop.sql at master · GXMUHATE/PL-SQL-Learning-Tutorial · GitHub

Sitelet https://github.com/GXMUHATE/PL-SQL-Learning-Tutorial/blob/master/SimpleLoop.sql

16 lines (16 loc) · 352 Bytes

SET SERVEROUTPUT ON;
    v_counter NUMBER := 0;
    v_result NUMBER;
    v_counter := v_counter +1;
    v_result := 19* v_counter;
    DBMS_OUTPUT.PUT_LINE('19'||' X '||v_counter||' = '|| v_result);
    --EXIT CONDITION
    --IF v_counter >= 10 THEN
      --  EXIT;
    --END IF;
    EXIT WHEN v_counter >= 10;
    END LOOP;