Note
This variable was introduced in V2.2.77.
Description
The nls_dual_currency variable specifies the local currency symbol for the U numeric format element.
Applicability
This variable applies only to the Oracle-compatible mode of OceanBase Database.
Privilege requirements
Query variables
Global level
Both the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle-compatible mode) to query the values of global system variables.Session level
Both the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle-compatible mode) to query the values of session system variables.
Modify variables
The value of this variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | $ |
| Effective scope |
|
| Modifiable | No, this variable is read-only. |