Note
This view is available starting with V2.2.30.
Purpose
This view displays the NLS parameters at the instance (tenant) level.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PARAMETER | VARCHAR2(128) | NO | The name of the parameter. |
| VALUE | VARCHAR2(65536) | YES | The value of the parameter. |
Sample query
Query the NLS parameters of the current tenant.
obclient> SELECT * FROM SYS.NLS_INSTANCE_PARAMETERS;
The query result is as follows:
+-------------------------+----------------------------------+
| PARAMETER | VALUE |
+-------------------------+----------------------------------+
| NLS_DATE_FORMAT | YYYY-MM-DD HH24:MI:SS |
| NLS_TIMESTAMP_FORMAT | YYYY-MM-DD HH24:MI:SS.FF |
| NLS_TIMESTAMP_TZ_FORMAT | YYYY-MM-DD HH24:MI:SS.FF TZR TZD |
| NLS_TERRITORY | AMERICA |
| NLS_SORT | BINARY |
| NLS_COMP | BINARY |
| NLS_CHARACTERSET | AL32UTF8 |
| NLS_NCHAR_CHARACTERSET | AL16UTF16 |
| NLS_DATE_LANGUAGE | AMERICAN |
| NLS_LENGTH_SEMANTICS | BYTE |
| NLS_NCHAR_CONV_EXCP | FALSE |
| NLS_CALENDAR | GREGORIAN |
| NLS_NUMERIC_CHARACTERS | ., |
+-------------------------+----------------------------------+
13 rows in set
References
Query the NLS parameters at the session level: NLS_SESSION_PARAMETERS
Query the NLS parameters at the database level: NLS_DATABASE_PARAMETERS
Query all NLS parameters at the session level: V$NLS_PARAMETERS