Note
This variable is available starting with OceanBase Database V2.2.77.
Description
nls_numeric_characters specifies the decimal separator and thousand separator in the string during the conversion between a number and a string.
Applicability
This variable is applicable only to OceanBase Database in Oracle mode.
Privilege requirements
Query variables
Global level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) to view the value of a Global system variable.Session level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) to view the value of a Session system variable.
Modify variables
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | ".," |
| Scope |
|
| Modifiable | No. This variable is read-only. |