WHILE STATEMENT
Description
Repeats a sequence of statements so long as the
boolean-expressionevaluates to true.
Click here to navigate to the PostgreSQL documentation page for this syntax.
While Statement is supported by Snowflake.
Grammar Syntax
[ <<label>> ]
WHILE boolean-expression LOOP
statements
END LOOP [ label ];Sample Source Patterns
Input
The only changes that are done to the If Statement, are the following
The boolean-expression is enclosed by parenthesis.
while counter < 5 loop
Select AValue from ATable;
end loop;WHILE (counter < 5) loop
Select AValue from ATable;
end loop;Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated
Was this helpful?