Note
This variable was introduced in V2.2.77.
Feature description
nls_dual_currency specifies the local currency symbol for the U 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 can neither modify the values of global nor session system variables in the
systenant or user tenants.
Attribute description
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | $ |
| Effective scope |
|
| Modifiability | No. This variable cannot be modified. |