Simple While Loop

PHOTO

Wed Sep 22 2021 21:57:41 GMT+0000 (Coordinated Universal Time)

DECLARE
	a number(2) := 10;
BEGIN
	WHILE a < 20 LOOP
    	dbms_output.put_line('value of a: ' || a);
		a := a + 1;
	END LOOP;
END

@kaveen

Simple For Loop Simple While Loop simple loop Labels Implicit Cursor Exercise 3 Explicit Cursor Into more columns Constant Variable Record If and elsif