与 Oracle“ALTER SYSTEM SET”命令相反
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9035695/
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
Opposite of Oracle "ALTER SYSTEM SET" Command
提问by mj_
I'm looking at some code and I see that someone is writing the following pl/sql.
我正在查看一些代码，我看到有人正在编写以下 pl/sql。
alter system set smtp_out_server = '123.345.134.123';
Since this is the mutator (setter), what's the accessor (getter) of this command?
既然这是 mutator (setter)，那么这个命令的访问器 (getter) 是什么？
SELECT what from where to view the SMTP_OUT_SERVER setting?
SELECT what 从哪里查看 SMTP_OUT_SERVER 设置？
Thanks,
谢谢，
mj
米
回答by John Doyle
Try:
尝试：
select *
from V$PARAMETER
where NAME = 'smtp_out_server';
Or, in an sqlplussession you can type:
或者，sqlplus您可以在会话中键入：
show parameter smtp_out_server
回答by Andrew
select * from v$parameter
That should get the settings, add a where clause for the specific one you are after
那应该得到设置，为您所追求的特定设置添加一个 where 子句
