Property | Description |
Parameter type | String |
Syntax |
|
Default value | Derived from |
Modifiable |
|
Range of values | Any valid character string, with a maximum of 10 bytes (not including null) |
Basic | No |
NLS_CURRENCY
specifies the string to use as the local currency symbol for the L number format element. The default value of this parameter is determined by NLS_TERRITORY
.
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_CURRENCY’;
NAME | VALUE | IS DEFAULT | ISSES_ MODIFIABLE | ISSYS_ MODIFIABLE | ISINSTANCE_ MODIFIABLE | IS DEPRECATED | DESCRIPTION |
nls_currency | | TRUE | TRUE | FALSE | FALSE | FALSE | NLS local currency symbol |
No comments:
Post a Comment