Feature
NLS_DATABASE_PARAMETERS describes National Language Support (NLS) parameters at the OceanBase Database tenant level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
V$NLS_PARAMETERS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| PARAMETER | VARCHAR2(128) | NO | The name of the parameter. |
| VALUE | VARCHAR2(65536) | YES | The value of the parameter. |
Examples
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)