NLS_ISO_CURRENCY

Property	Description
Parameter type	String
Syntax	NLS_ISO_CURRENCY = territory
Default value	Derived from NLS_TERRITORY
Modifiable	ALTER SESSION
Range of values	Any valid NLS_TERRITORY value

NLS_ISO_CURRENCY specifies the string to use as the international currency symbol for the C number format element.

Local currency symbols can be ambiguous. For example, a dollar sign ($) can refer to U.S. dollars or Australian dollars. ISO Specification 4217 1987-07-15 defines unique "international" currency symbols for the currencies of specific territories or countries.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘NLS_ISO_CURRENCY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_iso_currency		TRUE	TRUE	FALSE	FALSE	FALSE	NLS ISO currency territory name

Oracle initializatoin parameters