Note
This view is available starting with V2.2.30.
Purpose
This view displays all NLS parameters at the session 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. |
| CON_ID | NUMBER | NO | This column has no meaning. |
Sample query
Query all NLS parameters at the session level in the current tenant.
obclient> select * from V$NLS_PARAMETERS;
The query result is as follows:
+-------------------------+----------------------------------+--------+
| PARAMETER | VALUE | CON_ID |
+-------------------------+----------------------------------+--------+
| NLS_DATE_FORMAT | YYYY-MM-DD HH24:MI:SS | 0 |
| NLS_TIMESTAMP_FORMAT | YYYY-MM-DD HH24:MI:SS.FF | 0 |
| NLS_TIMESTAMP_TZ_FORMAT | YYYY-MM-DD HH24:MI:SS.FF TZR TZD | 0 |
| NLS_LANGUAGE | AMERICAN | 0 |
| NLS_TERRITORY | AMERICA | 0 |
| NLS_SORT | BINARY | 0 |
| NLS_COMP | BINARY | 0 |
| NLS_CHARACTERSET | AL32UTF8 | 0 |
| NLS_NCHAR_CHARACTERSET | AL16UTF16 | 0 |
| NLS_DATE_LANGUAGE | AMERICAN | 0 |
| NLS_LENGTH_SEMANTICS | BYTE | 0 |
| NLS_NCHAR_CONV_EXCP | FALSE | 0 |
| NLS_CALENDAR | GREGORIAN | 0 |
| NLS_NUMERIC_CHARACTERS | ., | 0 |
+-------------------------+----------------------------------+--------+
14 rows in set
References
Query NLS parameters at the tenant level: NLS_INSTANCE_PARAMETERS
Query NLS parameters at the database level: NLS_DATABASE_PARAMETERS
Query NLS parameters at the session level: NLS_SESSION_PARAMETERS