WHILE
Syntax
The statement list within a WHILE
statement is repeated as long as the search_condition
expression is true. statement_list
consists of one or more SQL statements, each terminated by a semicolon (;
) statement delimiter.
A WHILE
statement can be labeled. For the rules regarding label use, see , "Statement Label Syntax".
Example: