Oracle Enterprise Manager 11g 中的 NLS_CHARACTERSET 参数在哪里？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12235482/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Where is NLS_CHARACTERSET parameter in Oracle Enterprise Manager 11g?
提问by Centurion
Did logged into Enterprise Manager 11g via browser. There are NLS_TERRITORY, NLS_LANGUAGEand other NLSrelated params in In Server->Initialization Parameter->NLS group. But unable to find NLS_CHARACTERSETparameter. Explicit search of the parameters gives
是否通过浏览器登录到 Enterprise Manager 11g。In 中有NLS_TERRITORY,NLS_LANGUAGE和其他NLS相关参数Server->Initialization Parameter->NLS group。但是找不到NLS_CHARACTERSET参数。参数的显式搜索给出
"No parameters found".
“未找到参数”。
Is "select * from nls_database_parameters" the only way to view its value?
“select * from nls_database_parameters”是查看其值的唯一方法吗？
采纳答案by Matas Vaitkevicius
Answer from @OraNob gave me
@OraNob 的回答给了我
ORA-00942: table or view does not exist
However this worked for me:
但是这对我有用：
select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET');
回答by OraNob
try
尝试
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'
