SSC-FDM-OR0040

Numeric characters cannot be altered in Snowflake. The decimal separator in Snowflake is the dot character.

Description

Numeric characters cannot be altered in Snowflake. The decimal separator in Snowflake is the dot character. The ALTER session statement is commented and a warning is added.

Example Code

Oracle:

IN -> Oracle_01.sql
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';

Snowflake Scripting:

OUT -> Oracle_01.sql
----** SSC-FDM-OR0040 - NUMERIC CHARACTERS CANNOT BE ALTERED IN SNOWFLAKE. THE DECIMAL SEPARATOR IN SNOWFLAKE IS THE DOT CHARACTER. **
--ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.'
                                               ;

Recommendations

  • No end-user actions are required.

  • If you need more support, you can email us at [email protected]

Last updated