MSCEWI3062

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

Severity

Medium

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

Input Code:

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';

Output Code:

-- ** MSC-ERROR - MSCEWI3062 - NUMERIC CHARACTERS CANNOT BE ALTERED IN SNOWFLAKE. THE DECIMAL SEPARATOR IN SNOWFLAKE IS THE DOT CHARACTER. **
-- ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.'

Recommendations

Last updated