SHOW ALL 显示什么？
SQL*Plus 中 SHOW ALL 命令显示的变量的技术名称是什么？我想知道，因为“变量”这个词已经太多了，我想具体一点。
输入“help show”会显示：
SHOW
----
Shows the value of a SQL*Plus system variable, or the current
SQL*Plus environment. SHOW SGA requires a DBA privileged login.
...
列出的所有变量都被视为“SQL*Plus 系统变量”吗？我见过一些资料将它们称为“SQL*Plus 环境变量”，其他资料则将它们称为“参数”。
其中一些是“系统变量”，而另一些是“环境变量”/“参数”，或者这些术语可以互换，还是什么？
What is the technical name for the variables shown by the SHOW ALL command in SQL*Plus? I want to know because the term "variable" is quite overloaded and I'd like to be specific.
Typing "help show" says :
SHOW
----
Shows the value of a SQL*Plus system variable, or the current
SQL*Plus environment. SHOW SGA requires a DBA privileged login.
...
Are ALL of the variables listed considered "SQL*Plus system variables"? I've seen some sources which refer to them as "SQL*Plus environment variables", others which call them "parameters".
Are some of them "system variables" while others are "environment variables"/"parameters", or are these terms interchangeable, or what?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
根据 Oracle：
查看列表，它们实际上是仅在 SQL*Plus 中可用的所有变量。您看到它们以各种形式被提及并不奇怪，因为大多数人会使用对他们来说最有意义的术语，而不是查找规范术语。
如果您指定
SHOW PARAMETERS，您将获得 初始化参数，这完全是另外一回事。According to Oracle:
Looking at the list, they are, in fact, all variables that are available only within SQL*Plus. It's not terribly surprising that you see them referred to in various forms, as most people will use the term that makes the most sense to them, rather than looking up the canonical term.
If you specify
SHOW PARAMETERSinstead, you get a list of initialization parameters, which are something else altogether.