Example 9-8 illustrates the differences in the decimal character and group separator between the United States and Germany.
Example 9-8 Difference Between Number Formats by Locale (United States and Germany)
SQL> ALTER SESSION SET SET NLS_TERRITORY=america;
Session altered.
SQL> SELECT employee_id EmpID,
2 SUBSTR(first_name,1,1)||'.'||last_name "EmpName",
3 TO_CHAR(salary, '99G999D99') "Salary"
4 FROM employees
5* WHERE employee_id <105
EMPID EmpName Salary
---------- --------------------------- ----------
100 S.King 24,000.00
101 N.Kochhar 17,000.00
102 L.De Haan 17,000.00
103 A.Hunold 9,000.00
104 B.Ernst 6,000.00
SQL> ALTER SESSION SET SET NLS_TERRITORY=germany;
Session altered.
SQL> SELECT employee_id EmpID,
2 SUBSTR(first_name,1,1)||'.'||last_name "EmpName",
3 TO_CHAR(salary, '99G999D99') "Salary"
4 FROM employees
5* WHERE employee_id <105
EMPID EmpName Salary
---------- --------------------------- ----------
100 S.King 24.000,00
101 N.Kochhar 17.000,00
102 L.De Haan 17.000,00
103 A.Hunold 9.000,00
104 B.Ernst 6.000,00