About the NLS_ISO_CURRENCY Parameter

Specifies: ISO currency symbol (the character string returned by the numeric format element C).

Acceptable Values: Any valid currency symbol string.

Default Value: Set by NLS_TERRITORY, described in "About the NLS_TERRITORY Parameter".

Local currency symbols can be ambiguous, but ISO currency symbols are unique.

The following example shows that the territories AUSTRALIA and AMERICA have the same local currency symbol, but different ISO currency symbols.

To try this example in SQL Developer, enter the statements and queries in the SQL Worksheet. For information about the SQL Worksheet, see "Running Queries in SQL Developer". The results shown here are from SQL*Plus; their format is slightly different in SQL Developer.

NLS_ISO_CURRENCY

Note the current values of NLS_TERRITORY and NLS_ISO_CURRENCY.

For instructions, see "Viewing NLS Parameter Values".
If the value of NLS_TERRITORY in step 1 is not AUSTRALIA, change it:
```
ALTER SESSION SET NLS_TERRITORY=AUSTRALIA;
```

Run this query:

SELECT TO_CHAR(salary, 'L099G999D99') "Local",
        TO_CHAR(salary, 'C099G999D99') "ISO"
FROM EMPLOYEES
WHERE salary > 15000;

Result:

Local                 ISO
--------------------- ------------------
          $024,000.00      AUD024,000.00
          $017,000.00      AUD017,000.00
          $017,000.00      AUD017,000.00

Change the value of NLS_TERRITORY to AMERICA:

ALTER SESSION SET NLS_TERRITORY=AMERICA;

Run this query:

SELECT TO_CHAR(salary, 'L099G999D99') "Local",
        TO_CHAR(salary, 'C099G999D99') "ISO"
FROM EMPLOYEES
WHERE salary > 15000;

Result:

Local                 ISO
--------------------- ------------------
          $024,000.00      USD024,000.00
          $017,000.00      USD017,000.00
          $017,000.00      USD017,000.00

Set NLS_TERRITORY and NLS_ISO_CURRENCY to the values that they had at step 1.

About the NLS_ISO_CURRENCY Parameter

Related Topics