Purpose
The NLS_DATABASE_PARAMETERS view displays National Language Support (NLS) parameters at the OceanBase tenant level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
NLS_INSTANCE_PARAMETERSNLS_SESSION_PARAMETERSV$NLS_PARAMETERS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PARAMETER | VARCHAR2(128) | NO | The name of the parameter. |
| VALUE | VARCHAR2(65536) | YES | The value of the parameter. |
Example
obclient> SELECT * FROM SYS.NLS_DATABASE_PARAMETERS;
+-------------------------+----------------------------------+
| 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 (0.03 sec)