Oracle 参数 NLS_CURRENCY 官方解释，作用，如何配置最优化建议
本站中文解释
NLS_CURRENCY参数是格式化货币值的参数。该参数的缺省值是货币符号$ 。
NLS_CURRENCY的合法值是标准的ISO国际货币代码，如USD,JPY,GBP 等。要设定这个参数，请参考以下步骤：
1. 使用ALTER SESSION命令设定NLS_CURRENCY参数：
ALTER SESSION SET NLS_CURRENCY = ‘CNY’;
2. Linux/Unix上使用export方法：
export NLS_CURRENCY=’CNY’
3. Windows下使用 set 方法：
set NLS_CURRENCY=’CNY’
4. 使用Oracle属性设置工具：
通过Oracle属性设置工具，可以对NLS_CURRENCY参数进行设置 。
注意：设定NLS_CURRENCY参数后，必须提交当前会话，重启实例，以便使参数生效。
官方英文解释
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.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
Derived from |
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
Any valid character string, with a maximum of 10 bytes (not including null) |
|
Basic |
No |
Note:
The value of this initialization parameter NLS_CURRENCY is used to initialize the session value of this parameter, which is the actual value referenced by the SQL query processing. This initial value is overridden by a client-side value if the client uses the Oracle JDBC driver or if the client is OCI-based and the NLS_LANG client setting (environment variable) is defined. The initialization parameter value is, therefore, usually ignored.
See Also:
-
Oracle Database
Globalization Support Guide for more information about this parameter -
Oracle Database SQL
Language Reference for information on number format elements
