Oracle下各个NLS相关参数取得方法

磨砺技术珠矶，践行数据之道，追求卓越价值

回到上一级页面： PostgreSQL杂记页     回到顶级页面：PostgreSQL索引页 

[作者 高健@博客园  luckyjackgao@gmail.com] 

 

1)---------------------------------------------------------------------------------------------------------

NLS_NCHAR_CHARACTERSET：

SQL> select * from nls_database_parameters where parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
UTF8
SQL>

 

2)---------------------------------------------------------------------------------------------------------

NLS_LANGUAGE：

SQL> show parameter NLS_LANGUAGE;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_language                         string      JAPANESE
SQL>

 

3)---------------------------------------------------------------------------------------------------------

NLS_TERRITORY：

SQL> show parameter NLS_TERRITORY;
show parameter NLS_TERRITORY;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_territory                        string      JAPAN
SQL>

 

4)---------------------------------------------------------------------------------------------------------
NLS_CURRENCY：
SQL> show parameter NLS_CURRENCY;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_currency                         string      ¥
SQL>

 

5)---------------------------------------------------------------------------------------------------------

NLS_ISO_CURRENCY：

SQL> show parameter NLS_ISO_CURRENCY;
show parameter NLS_ISO_CURRENCY;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_iso_currency                     string      JAPAN
SQL>

  

6)---------------------------------------------------------------------------------------------------------

NLS_NUMERIC_CHARACTERS：

SQL> show parameter NLS_NUMERIC_CHARACTERS;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_numeric_characters               string      .,
SQL>

 

7)---------------------------------------------------------------------------------------------------------

NLS_CHARACTERSET：

SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
JA16SJIS
SQL>

 

8)---------------------------------------------------------------------------------------------------------

NLS_CALENDAR:

SQL> show parameter NLS_CALENDAR;
show parameter NLS_CALENDAR;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_calendar                         string      GREGORIAN
SQL>

 

9)----------------------------------------------------------------------------------------------------------

NLS_DATE_FORMAT:

SQL> show parameter NLS_DATE_FORMAT;
show parameter NLS_DATE_FORMAT;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_date_format                      string      RR-MM-DD
SQL> 

 

10)----------------------------------------------------------------------------------------------------------

NLS_DATE_LANGUAGE:

SQL> show parameter NLS_DATE_LANGUAGE;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_date_language                    string      JAPANESE
SQL>

 

11)----------------------------------------------------------------------------------------------------------

NLS_SORT:

SQL> show parameter NLS_SORT;
show parameter NLS_SORT;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string      BINARY
SQL>

 

12)----------------------------------------------------------------------------------------------------------

NLS_TIME_FORMAT:

SQL> show parameter NLS_TIME_FORMAT;
show parameter NLS_TIME_FORMAT;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_time_format                      string      HH24:MI:SSXFF
SQL>

 

13)----------------------------------------------------------------------------------------------------------

NLS_TIMESTAMP_FORMAT:

SQL> show parameter NLS_TIMESTAMP_FORMAT;
AMP_FORMAT;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_timestamp_format                 string      RR-MM-DD HH24:MI:SSXFF
SQL>

 

14)----------------------------------------------------------------------------------------------------------

NLS_TIME_TZ_FORMAT：

SQL> show parameter NLS_TIME_TZ_FORMAT;
show parameter NLS_TIME_TZ_FORMAT;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_time_tz_format                   string      HH24:MI:SSXFF TZR
SQL>

 

15)----------------------------------------------------------------------------------------------------------

NLS_TIMESTAMP_TZ_FORMAT:

SQL> select * from nls_database_parameters where parameter='NLS_TIMESTAMP_TZ_FORMAT';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
SQL>

 

16)----------------------------------------------------------------------------------------------------------

NLS_DUAL_CURRENCY:

SQL> show parameter NLS_DUAL_CURRENCY;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_dual_currency                    string      ¥
SQL> 

 

17)----------------------------------------------------------------------------------------------------------

NLS_COMP:

SQL> show parameter NLS_COMP;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_comp                             string      BINARY
SQL>

 

18)----------------------------------------------------------------------------------------------------------

NLS_LENGTH_SEMANTICS:

SQL> show parameter NLS_LENGTH_SEMANTICS;
show parameter NLS_LENGTH_SEMANTICS;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics                 string      BYTE
SQL> 

 

19)----------------------------------------------------------------------------------------------------------

NLS_NCHAR_CONV_EXCP:

SQL> show parameter NLS_NCHAR_CONV_EXCP;
show parameter NLS_NCHAR_CONV_EXCP;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_nchar_conv_excp                  string      FALSE
SQL>

 

20)-------------------

NLS_RDBMS_VERSION:

SQL> select property_value from database_properties where property_name='NLS_RDBMS_VERSION';
select property_value from database_properties where property_name='NLS_RDBMS_VERSION';
PROPERTY_VALUE
--------------------------------------------------------------------------------

11.2.0.3.0
SQL> 

 

[作者 高健@博客园  luckyjackgao@gmail.com] 

回到上一级页面： PostgreSQL杂记页     回到顶级页面：PostgreSQL索引页 

磨砺技术珠矶，践行数据之道，追求卓越价值