Set
Last updated
Last updated
Transformation for this command is pending
The
SET
command sets a system variable to alter the SQL*Plus environment settings for your current session. ()
This case is functionally equivalent.
The SET
command is replaced by the command.
This case is not functionally equivalent.
Oracle allows bypassing the key-value rule for assigning values to system variables with a numeric domain, assigning the value of 0 by default in such cases. In Snowflake this is not allowed, so an alternative is to set the value of 0 to a said variable explicitly.
1. Predefined variables
No related EWIs.
The SET command only works for system variables, which may differ in quantity, name, or domain between the two languages, so a review should be done on the variable being used within the command to find its correct Snowflake equivalence. To see the list of system variables in Oracle you can use the command SHOW ALL
whereas in Snowflake you can use .