Note
This variable was introduced in V2.2.77.
Description
nls_currency specifies the local currency symbol for the L number format element.
Applicability
This variable applies only to the Oracle mode of OceanBase Database.
Privilege requirements
Query variables
Global scope
Tenants in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) to view the values of global system variables.Session scope
Tenants in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle mode) to view the values of session system variables.
Modify variables
Tenants, including the
systenant and all user tenants, cannot modify the values of global or session system variables in their own tenants.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | $ |
| Effective scope |
|
| Modifiability | No, this variable cannot be modified. |