Note
This variable is available starting with V2.2.77.
Overview
nls_language specifies the default language for database internationalization, which is used for prompts, dates, month names, and as the default value for NLS_SORT and NLS_DATE_LANGUAGE.
Applicability
This variable applies only to OceanBase Database in Oracle-compatible mode.
Privilege requirements
Query variables
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle-compatible mode) to view the values of session system variables.Modify variables
The
systenant and all user tenants cannot modify the values of session system variables for their own tenants.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Varchar |
| Default Value | AMERICA |
| Effective Scope | Session |
| Modifiable | No, this variable cannot be modified. |