Note
This variable was introduced in V2.2.77.
Feature 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 of 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 of 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 of the
systenant and all user tenants cannot modify the values of global or session system variables of their own.
Attribute description
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | $ |
| Applicable scope |
|
| Modifiability | No. This variable cannot be modified. |