关于NLS_INSTANCE_PARAMETERS的显示内容

Question

SQL> select * from NLS_SESSION_PARAMETERS;PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_LANGUAGE                   SIMPLIFIED CHINESE
NLS_TERRITORY                  CHINA
NLS_CURRENCY                   ￥
NLS_ISO_CURRENCY               CHINA
NLS_NUMERIC_CHARACTERS         .,
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              SIMPLIFIED CHINESE
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              ￥
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSESQL> select * from NLS_INSTANCE_PARAMETERS;PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_SORT                       
NLS_DATE_LANGUAGE              
NLS_DATE_FORMAT                
NLS_CURRENCY                   
NLS_NUMERIC_CHARACTERS         
NLS_ISO_CURRENCY               
NLS_CALENDAR                   
NLS_TIME_FORMAT                
NLS_TIMESTAMP_FORMAT           
NLS_TIME_TZ_FORMAT             
NLS_TIMESTAMP_TZ_FORMAT        
NLS_DUAL_CURRENCY              
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
为什么NLS_SESSION_PARAMETERS中显示的内容有一部分在NLS_INSTANCE_PARAMETERS中没有显示

Answer 1

--自己查看一下它的定义
select * from dba_views t where t.VIEW_NAME like 'NLS%';

Answer 2

SQL> select text from dba_views t where t.VIEW_NAME like 'NLS%';TEXT
--------------------------------------------------
select name,
       substr(value$, 1, 40)where name like 'NLS%'select substr(upper(name), 1, 30),from props$
       substr(value, 1, 40)
from v$parameteselect substr(parameter, 1, 30),
       substr(value, 1, 40)
from v$nls_parame关键是这吧from props$、from v$parameter、from v$nls_parameter，但还是不得要领，请指点。

Answer 3

而且如何格式化才能让from v$paramete和from v$nls_parame
后面显示完整

Answer 4

up               up