Note
The variable is available since V2.2.77.
Description
nls_iso_currency specifies the local currency symbol for the C number format element.
Function Applicability
This variable is applicable only to OceanBase Database in Oracle mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can query global system variables by using theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode).Session level
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) to view the values of session system variables.
Modify variables
You cannot modify this variable.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | AMERICA |
| Applicable scope | |
| Writable | No. The value of this variable is read-only. |