oracle global,ORACLE GLOBAL

区别nls_database_parameters与v$nls_parameters

实验1：(测试于PL/SQL Develper)

先看看v$nls_parameters....[@more@]

select * from v$nls_parameters

1 NLS_LANGUAGE SIMPLIFIED CHINESE

2 NLS_TERRITORY CHINA

3 NLS_CURRENCY ￥

4 NLS_ISO_CURRENCY CHINA

5 NLS_NUMERIC_CHARACTERS .,

6 NLS_CALENDAR GREGORIAN

7 NLS_DATE_FORMAT DD-MON-RR

8 NLS_DATE_LANGUAGE SIMPLIFIED CHINESE

9 NLS_CHARACTERSET ZHS16GBK

10 NLS_SORT BINARY

11 NLS_TIME_FORMAT HH.MI.SSXFF AM

12 NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

13 NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

14 NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

15 NLS_DUAL_CURRENCY ￥

16 NLS_NCHAR_CHARACTERSET AL16UTF16

17 NLS_COMP BINARY

18 NLS_LENGTH_SEMANTICS BYTE

19 NLS_NCHAR_CONV_EXCP FALSE

------------------------------------------------------------------

再看下nls_database_parameters

select * from nls_database_parameters

1 NLS_LANGUAGE AMERICAN

2 NLS_TERRITORY AMERICA

3 NLS_CURRENCY $

4 NLS_ISO_CURRENCY AMERICA

5 NLS_NUMERIC_CHARACTERS .,

6 NLS_CHARACTERSET ZHS16GBK

7 NLS_CALENDAR GREGORIAN

8 NLS_DATE_FORMAT DD-MON-RR

9 NLS_DATE_LANGUAGE AMERICAN

10 NLS_SORT BINARY

11 NLS_TIME_FORMAT HH.MI.SSXFF AM

12 NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

13 NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

14 NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

15 NLS_DUAL_CURRENCY $

16 NLS_COMP BINARY

17 NLS_LENGTH_SEMANTICS BYTE

18 NLS_NCHAR_CONV_EXCP FALSE

19 NLS_NCHAR_CHARACTERSET AL16UTF16

20 NLS_RDBMS_VERSION 10.1.0.2.0

---------------------------------------------------------------------

虽然结构与内容很类似 但对比后不难发现他们的区别

语言地域等都有极大差别

还有值得注意的是 其中nls_database_parameters最后一列

NLS_RDBMS_VERSION 描述了关系数据库的版本

为什么再v$nls_parameters中没有描述呢

实验2：(测试于isqlplus)

SQL> show parameter nls_lang

NAME TYPE VALUE

------------------------------------ ----------- --------------------

nls_language string SIMPLIFIED CHINESE

这里我们暂时猜测v$nls_parameters 中的值

进一步验证

SQL> alter session set nls_language='AMERICAN';

Session altered.

将当前会话的语言修改为AMERICAN

再次查询v$nls_parameters

SQL> select * from V$NLS_PARAMETERS WHERE PARAMETER='NLS_LANGUAGE';

PARAMETER VALUE

------------------------------ ------------------------------

NLS_LANGUAGE AMERICAN

--=== 总结 v$nls_parameters 其中的参数为当前session的参数

而nls_database_parameters 为数据库的参数