Oracle PL/SQL Tutorial

LOOP

LOOP example

  
DECLARE 
	v_num NUMBER:=0;
BEGIN
	LOOP 
		v_num:=v_num+1;
		DBMS_OUTPUT.put_line(v_num);
		IF v_num = 3 THEN
			EXIT;  
		END IF;
	END LOOP;
END;

Output:

1
2
3