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

2022-04-13 01:27:21

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>

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3298240.html，如需转载请自行联系原作者

码农公寓

相关文章