Database-loop statement: while Loop/end loop

While Loop statement:

1: Grammar

--While loop syntax:
While < Boolean expression > (executes loop when expression is established) loop
The statement to execute;
END LOOP;
Where: The order of execution of the loop statement is to judge the true and false of the < Boolean expression >, if it is true, the loop executes, otherwise exits the loop.
Exit or exit when clauses can still be used in a while loop statement

2: Example

Declare
V_x Number (2): = 1;
Begin
While v_x<=10 loop
V_x: =v_x+1;
Dbms_output.put_line (' x Current value is: ' | | V_X);
End Loop;
End

Database-loop statement: while Loop/end loop