nls_territory

2025-11-14 07:33:33  Updated

Note

This variable is available starting with OceanBase Database V2.2.77.

Description

nls_territory specifies the current territory in the database internationalization support. It is used in conjunction with nls_language.

Applicability

This variable is applicable only to OceanBase Database in Oracle mode.

Privilege requirements

  • Query variables

    • Global level

      sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) to view the value of a Global system variable.

    • Session level

      sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) to view the value of a Session system variable.

  • Modify variables

    You cannot modify this variable.

Attributes

Attribute Description
Type Varchar
Default value AMERICA
Scope
  • Global
  • Session
Modifiable No. This variable is read-only.

Contact Us