Using the NLS_ISO_CURRENCY Parameter
Establishing a Globalization Support Environment
6-20 Oracle Database 2 Day Developer's Guide
SELECT TO_CHAR(salary, 'L099G999D99') "salary" FROM employees
WHERE salary > 11000
The output from the example should be similar to the following. The dollar sign
($) is the
L
number format model in this case.
salary
---------------------
$024,000.00
$017,000.00
$017,000.00
$012,000.00
$014,000.00
$013,500.00
$012,000.00
$011,500.00
$013,000.00
$012,000.00
10 rows selected
Using the NLS_ISO_CURRENCY Parameter
The
NLS_ISO_CURRENCY
parameter specifies the character string returned by the
C
number format model, the ISO currency symbol. Setting
NLS_ISO_CURRENCY
overrides the default value defined implicitly by
NLS_TERRITORY
. The value can be
any valid string.
Local currency symbols can be ambiguous. For example, a dollar sign ($) can refer to
U.S. dollars or Australian dollars. ISO specifications define unique currency symbols
for specific territories or countries. For example, the ISO currency symbol for the U.S.
dollar is USD, and the ISO currency symbol for the Australian dollar is AUD.
The
NLS_ISO_CURRENCY
parameter has the same syntax as the
NLS_TERRITORY
parameter, and all supported territories are valid values.
To set the NLS_ISO_CURRENCY parameter:
The following example sets the ISO currency symbol for France, and formats salaries
using the appropriate format model.
1.
In SQL Developer, make a note of the ISO currency format in which Oracle
Database was installed.
Under Connections, expand Data Dictionary reports, then About Your Database,
and then National Language Support Parameters. In the Select Connection dialog
box, select
hr_conn
from the list of connections. The current ISO currency format
is listed after
NLS_ISO_CURRENCY
.
See Also:
Oracle Database Reference for more information on the
NLS_
CURRENCY
parameter.
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment,
including monetary parameters
