CURSOR
Description
For more information regarding the Cursor declaration, check here.
This section covers the Translation Reference for Oracle Explicit Cursor. For Oracle Cursor Variables there is no equivalent in Snowflake Scripting.
Some parts in the output code are omitted for clarity reasons.
Cursors are pointers that allow users to iterate through query results. For more information on Oracle Cursors check here.
Cursor Definition
Cursor Open
Cursor Fetch
Cursor Close
Cursor Attributes
Cursor FOR Loop
Snowflake Scripting has support for cursors, however, they have fewer functionalities compared to Oracle. To check more information regarding these cursors, check here.
Cursor Declaration
Cursor Open
Cursor Fetch
Cursor Close
Cursor FOR Loop
Sample Source Patterns
1. Basic cursor example
IN -> Oracle_01.sql
OUT -> Oracle_01.sql
2. Explicit Cursor For Loop
IN -> Oracle_02.sql
OUT -> Oracle_02.sql