NLS_NUMERIC_CHARACTERS
Parameter type | String |
Syntax | NLS_NUMERIC_CHARACTERS = "decimal_character group_separator" |
Default value | Derived from NLS_TERRITORY |
Parameter class | Dynamic: ALTER SESSION |
NLS_NUMERIC_CHARACTERS specifies the characters to use as the group separator and decimal character. It overrides those characters defined implicitly by NLS_TERRITORY. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.
You can specify any character as the decimal or group separator. The two characters specified must be single-byte and must be different from each other. The characters cannot be any numeric character or any of the following characters: plus (+), minus sign (-), less than sign (<), greater than sign (>). Either character can be a space.
For example, if you wish to specify a comma as the decimal character and a space as the group separator, you would set this parameter as follows:
NLS_NUMERIC_CHARACTERS = ", "
NLS_NUMERIC_CHARACTERS
Parameter type | String |
Syntax | NLS_NUMERIC_CHARACTERS = "decimal_character group_separator" |
Default value | Derived from NLS_TERRITORY |
Parameter class | Dynamic: ALTER SESSION |
NLS_NUMERIC_CHARACTERS specifies the characters to use as the group separator and decimal character. It overrides those characters defined implicitly by NLS_TERRITORY. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.
You can specify any character as the decimal or group separator. The two characters specified must be single-byte and must be different from each other. The characters cannot be any numeric character or any of the following characters: plus (+), minus sign (-), less than sign (<), greater than sign (>). Either character can be a space.
For example, if you wish to specify a comma as the decimal character and a space as the group separator, you would set this parameter as follows:
NLS_NUMERIC_CHARACTERS = ", "
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9078678/viewspace-45120/ ，如需转载，请注明出处，否则将追究法律责任。
