Note
This variable was introduced in V2.2.77.
Description
nls_language specifies the default language of prompt messages, date, month, and the default values of nls_sort and nls_date_language.
Applicability
This variable applies only to the Oracle-compatible mode of OceanBase Database.
Privilege requirements
Query variables
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 session system variables in their own tenants.
Attribute description
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | AMERICA |
| Effective scope | Session |
| Modifiability | No, this variable cannot be modified. |