[php]
NCV31@ncts>select text from dba_views where view_name='NLS_DATABASE_PARAMETERS';
TEXT
--------------------------------------------------------------------------------
select name,
substr(value$, 1, 40)
from props$
where name like 'NLS%'
NCV31@ncts>select object_type from dba_objects where object_name='V$NLS_PARAMETERS';
OBJECT_TYPE
------------------
SYNONYM
NCV31@ncts>select * from dba_synonyms where synonym_name='V$NLS_PARAMETERS';
OWNER
SYNONYM_NAME
TABLE_OWNER
TABLE_NAME
------------------------------ ------------------------------ ------------------------------ --------------------------
PUBLIC
V$NLS_PARAMETERS
SYS
V_$NLS_PARAMETERS
NCV31@ncts>select object_type from dba_objects where object_name='V_$NLS_PARAMETERS';
OBJECT_TYPE
------------------
VIEW
NCV31@ncts>select text from dba_views where view_name='V_$NLS_PARAMETERS';
TEXT
--------------------------------------------------------------------------------
select "PARAMETER","VALUE" from v$nls_parameters
NCV31@ncts>select * from dict where table_name like '%FIXED%';
TABLE_NAME
COMMENTS
------------------------------ -----------------------------------------------------------------------
GV$FIXED_TABLE
Synonym for GV_$FIXED_TABLE
GV$FIXED_VIEW_DEFINITION Synonym for GV_$FIXED_VIEW_DEFINITION
GV$INDEXED_FIXED_COLUMN
Synonym for GV_$INDEXED_FIXED_COLUMN
V$FIXED_TABLE
Synonym for V_$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
Synonym for V_$FIXED_VIEW_DEFINITION
V$INDEXED_FIXED_COLUMN Synonym for V_$INDEXED_FIXED_COLUMN
SYS@ncts>select * FROM GV$FIXED_VIEW_DEFINITION WHERE VIEW_NAME='V$NLS_PARAMETERS';
INST_ID VIEW_NAME
VIEW_DEFINITION
---------- ------------------------------ ---------------------------------------------------------------------------------------
1
V$NLS_PARAMETERS
selectPARAMETER , VALUE from GV$NLS_PARAMETERS where inst_id = USERENV('Instance')
SYS@ncts>select * FROM GV$FIXED_VIEW_DEFINITION WHERE VIEW_NAME='GV$NLS_PARAMETERS';
INST_ID VIEW_NAME
VIEW_DEFINITION
---------- ----------------------------------------------------------------------------------------------------------------------------
1
GV$NLS_PARAMETERS
select inst_id,parameter, value from x$nls_parameters where parameter != 'NLS_SPECIAL_CHARS'
此问题酬劳:200PB,谢谢!
[/php]
此问题酬劳:200PB,谢谢! |