nls_numeric_characters

2026-02-12 02:58:32  Updated

Note

This variable is available starting with V2.2.77.

Description

nls_numeric_characters specifies the decimal and thousand separators used in string-to-number conversion.

Applicability

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

Privilege requirements

  • Query variables

    • Global level

      The sys tenant 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

      The sys tenant 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

    This variable cannot be modified.

Attributes

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

Contact Us