Name

NLS_NUMERIC_CHARACTERS

Synopsis

Value: see description

Default: derived

Dynamic: ALTER SESSION

Specifies the characters to use as the group separator and decimal. This parameter setting overrides those defined implicitly by NLS_TERRITORY.

The two characters specified must be single-byte, and the characters must be different from each other. The characters cannot be any numeric character or any of the following characters: plus (+), hyphen (-), less-than sign (<), greater-than sign (>). The characters are specified in the following format:

NLS_NUMERIC_CHARACTERS = "<decimal_character><group_separator>"

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.