SSC-FDM-OR0040

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

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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