Snowflake Scripting-Referenz¶

-- Variable declaration
[ DECLARE ... ]
  ...
BEGIN
  ...
  -- Branching
  [ IF ... ]
  [ CASE ... ]

  -- Looping
  [ FOR ... ]
  [ WHILE ... ]
  [ REPEAT ... ]
  [ LOOP ... ]

  -- Loop termination (within a looping construct)
  [ BREAK ]
  [ CONTINUE ]

  -- Variable assignment
  [ LET ... ]

  -- Cursor management
  [ OPEN ... ]
  [ FETCH ... ]
  [ CLOSE ... ]

  -- "No-op" (no-operation) statement (usually within a branch or exception)
  [ NULL ]

  -- Raising exceptions
  [ RAISE ... ]

  -- Returning a value
  [ RETURN ... ]

-- Exception handling
[ EXCEPTION ... ]

END;