Use of stored procedures (2) conditional statements and loop statements

Conditional statement part

Loop statement: Yes

**1. The statement executed UNTIL the conditional expression is True is executed UNTIL the conditional expression END REPEAT;

**2.**WHILE conditional expression DO series statements END WHILE

The difference between a while loop statement and a repeat loop control statement is that the former will not execute until the condition is met once in the loop body, while the latter will execute at least once regardless of whether the condition is met, which can be seen from the previous case. The syntax for the while loop is as follows:

The definitions for variables and declared variables are at the top, and you can look at them