Last updated
Last updated
With each iteration of the
FOR
LOOP
statement, its statements run, its index is either incremented or decremented, and control returns to the top of the loop. ().
Snowflake Scripting supports FOR LOOP
that loops a specified number of times. The upper and lower bounds must be INTEGER
. Check more information in the .
Oracle FOR LOOP
behavior can also be modified by using the statements:
GOTO
This case is functionally equivalent.
Transformation for custom types is currently not supported for Snowflake Scripting.
Oracle allows multiple conditions in a single FOR LOOP
however, Snowflake Scripting only allows one condition per FOR LOOP
. Only the first condition is migrated and the others are ignored during transformation. Check SSC-FDM-OR0022.
2. Mutable vs Inmutable Counter Variable
3. Integer vs Float number for Upper or Lower Bound
4. Oracle Unsupported Clauses
5. Unsupported Formats
Oracle allows modifying the value of the FOR LOOP
variable inside the loop. The includes this functionality but Snowflake recommends avoiding this. Modifying the value of this variable may not behave correctly in Snowflake Scripting.
Snowflake Scripting only allows an INTEGER
or an expression that evaluates to an INTEGER
as a bound for the FOR LOOP
condition. Floating numbers will be rounded up or down and alter the original bound. Check .
Oracle allows additional clauses to the FOR LOOP
condition. Like the BY clause for a stepped increment in the condition. And the WHILE and WHEN clause for boolean expressions. These additional clauses are not supported in Snowflake Scripting and are ignored during transformation. Check .
Oracle allows different types of conditions for a FOR LOOP
. It supports boolean expressions, collections, records... However, Snowflake scripting only supports FOR LOOP
with defined integers as bounds. All other formats are marked as not supported and require additional manual effort to be transformed. Check .
: Functionality is not currently supported by Snowflake Scripting.
: Custom type usage changed to variant.
: For Loop With Multiple Conditions Is Currently Not Supported By Snowflake Scripting. Only First Condition Is Used.
: Specific For Loop Clause Is Currently Not Supported By Snowflake Scripting.
: For Loop Format Is Currently Not Supported By Snowflake Scripting.