ORACLE - NLS_NUMERIC_CHARACTERS, Decimal character and Group Separator

The NLS_NUMERIC_CHARACTERS parameter explicitly specifies a new decimal character and group separator.

The text value must have this form: 'dg'
- d is the new decimal character.
- g is the new group separator.

The decimal character and the group separator must be two different single-byte characters, and cannot be a numeric value or any of the following characters: plus sign ("+"), less-than sign ("<"), minus sign or hyphen ("-" ), or greater-than sign (">").
If the decimal character is not a period (.), you must use single quotation marks to enclose all number values that appear in expressions in your SQL statements.
When not using a period for the decimal point, use the TO_NUMBER function to ensure that a valid number is retrieved.


EXAMPLE 1 :
to_number( products.price, '999G999G999D999999', 'NLS_NUMERIC_CHARACTERS = ''.,''')

EXAMPLE 2 :
to_number(products.price, '999G999G999D999999', 'NLS_NUMERIC_CHARACTERS = ''.,''')

EXAMPLE 3 :
SELECT to_number('10.123456', '999G999G999D999999',
'NLS_NUMERIC_CHARACTERS = ''.,''') FROM DUAL

More Oracle
Mas Oracle