C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
PL/SQL While LoopPL/SQL while loop is used when a set of statements has to be executed as long as a condition is true, the While loop is used. The condition is decided at the beginning of each iteration and continues until the condition becomes false. Syntax of while loop: WHILE Example of PL/SQL While LoopLet's see a simple example of PL/SQL WHILE loop. DECLARE i INTEGER := 1; BEGIN WHILE i <= 10 LOOP DBMS_OUTPUT.PUT_LINE(i); i := i+1; END LOOP; END; After the execution of the above code, you will get the following result: 1 2 3 4 5 6 7 8 9 10 Note: You must follow these steps while using PL/SQL WHILE Loop.
PL/SQL WHILE Loop Example 2DECLARE VAR1 NUMBER; VAR2 NUMBER; BEGIN VAR1:=200; VAR2:=1; WHILE (VAR2<=10) LOOP DBMS_OUTPUT.PUT_LINE (VAR1*VAR2); VAR2:=VAR2+1; END LOOP; END; Output: 200 400 600 800 1000 1200 1400 1600 1800 2000
Next TopicPL/SQL FOR Loop
|