Text literals
Description
Use the text literal notation to specify values whenever
string
appears in the syntax of expressions, conditions, SQL functions, and SQL statements in other parts of this reference.
Sample Source Patterns
Empty string ('')
The empty strings are equivalent to NULL in Oracle, so in order to emulate the behavior in Snowflake, the empty strings are converted to NULL or undefined depending if the literal is used inside a procedure or not.
Oracle
IN -> Oracle_01.sql
Snowflake
OUT -> Oracle_01.sql
Empty string in stored procedures
Oracle
IN -> Oracle_02.sql
Snowflake
OUT -> Oracle_02.sql
Empty string in built-in functions
The transformation does not apply when the empty string is used as an argument of the REPLACE and CONCAT functions in order to keep the functional equivalence.
Oracle
IN -> Oracle_03.sql
Snowflake
OUT -> Oracle_03.sql