The NLS_TERRITORY option specifies current territory for the session.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSION SET option = value.
See Oracle Database Globalization Support Guide for more information about NLS database parameters.
Example 5-79 Effects of Changing NLS_TERRITORY
In this example, the NLS_LANG option is initially set to:
AMERICAN_AMERICA.WE8ISO8859P1
The thousands marker is a comma (,), and the decimal marker is a period (.).
SHOW TO_NUMBER('12345')
12,345.00
A change to the territory setting:
NLS_TERRITORY = 'FRANCE'
changes the value of NLS_LANG to
AMERICAN_FRANCE.WE8ISO8859P1
The thousands marker is now a period (.), and the decimal marker is a comma (,).
SHOW TO_NUMBER('12345')
12.345,00