NLS_DUAL_CURRENCY

Property	Description
Parameter type	String
Syntax	NLS_DUAL_CURRENCY = currency_symbol
Default value	Derived from NLS_TERRITORY
Modifiable	ALTER SESSION
Range of values	Any valid format name up to 10 characters

NLS_DUAL_CURRENCY specifies the dual currency symbol (such as "Euro") for the territory. The default is the dual currency symbol defined in the territory of your current language environment.

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_DUAL_CURRENCY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_dual_currency		TRUE	TRUE	FALSE	FALSE	FALSE	Dual currency symbol

Oracle initializatoin parameters