Oracle Loop
Simple Loop
DECLARE
v_counter NUMBER(2);
BEGIN
v_counter := 0;
LOOP
v_counter := v_counter + 1;
DBMS_OUTPUT.put_line('Line number' || v_counter);
EXIT WHEN v_counter = 10;
END LOOP;
END;
DECLARE
v_counter NUMBER(2);
BEGIN
v_counter := 0;
LOOP
v_counter := v_counter + 1;
DBMS_OUTPUT.put_line('Line number' || v_counter);
EXIT WHEN v_counter = 10;
END LOOP;
END;
In this page (written and validated by A. Gawali) you learned about Oracle Loop . What's Next? If you are interested in completing Oracle tutorial, your next topic will be learning about: Oracle WHILE Loop.
Share On: |