Coder Circle

Your Path for Knowledge to Wisdom

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About
  • Web

Tag Archives: PL/SQL

Loop in PL/SQL

Posted on January 25, 2008 by admin
1

The example given below shows a While Loop. Here the value of the variable I is checked to ascertain whether it is less than 10 and as long as it is so the body of the loop will be executed.

DECLARE
I NUMBER (4) :=0;
BEGIN
WHILE (I<10)
LOOP
I:= I+1;
DBMS_OUTPUT.PUT_LINE (I);
END LOOP;
END;

Posted in Database | Tagged database programming, oracle, PL/SQL, while loop | 1 Reply
Proudly powered by WordPress