| 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