Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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
.
TEXT
NLS_TERITORRY = 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