Using the NLS_DUAL_CURRENCY Parameter
Establishing a Globalization Support Environment
Working in a Global Environment 6-21
2.
Set
NLS_ISO_CURRENCY
to France.
ALTER SESSION SET NLS_ISO_CURRENCY=FRANCE;
3.
Display selected salaries using that format.
SELECT TO_CHAR(salary, 'C099G999D99') "Salary" FROM employees
WHERE department_id = 60;
The output from the example should be similar to the following.
Salary
------------------
EUR009,000.00
EUR006,000.00
EUR004,800.00
EUR004,800.00
EUR004,200.00
5 rows selected
4.
Set
NLS_ISO_CURRENCY
back to its original setting listed in Step 1. For example:
ALTER SESSION SET NLS_ISO_CURRENCY=AMERICA;
Using the NLS_DUAL_CURRENCY Parameter
Use the
NLS_DUAL_CURRENCY
parameter to override the default dual currency
symbol defined implicitly by
NLS_TERRITORY
. The value can be any valid symbol.
NLS_DUAL_CURRENCY
was introduced to support the euro currency symbol during
the euro transition period.
See Also:
Oracle Database Reference for more information on the
NLS_ISO_
CURRENCY
parameter
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment,
including monetary parameters
See Also:
Oracle Database Reference for more information on the
NLS_DUAL_
CURRENCY
parameter
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment,
including monetary parameters
