CONTINUE
Translation reference to convert Oracle CONTINUE statement to Snowflake Scripting
Description
The
CONTINUE
statement exits the current iteration of a loop, either conditionally or unconditionally, and transfers control to the next iteration of either the current loop or an enclosing labeled loop. (Oracle PL/SQL Language Reference CONTINUE Statement)
Some parts in the output code are omitted for clarity reasons.
Sample Source Patterns
1. Simple Continue
Code skips the INSERT
statement by using CONTINUE
.
This case is functionally equivalent.
Oracle
IN -> Oracle_01.sql
Snowflake Scripting
OUT -> Oracle_01.sql
2. Continue with condition
Code skips inserting even numbers by using CONTINUE
.
This case is not functionally equivalent, but, you can turn the condition into an IF
statement.
Oracle
IN -> Oracle_02.sql