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
Neither the
systenant nor any user tenants can modify the values of global or session system variables in their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | $ |
| Effective scope |
|
| Modifiable | No, this variable is not modifiable. |