oracle SQL*Plus 中的“2”是什么意思？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7700855/
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
what does the "2"mean in SQL*Plus?
提问by kaiwii ho
I am new to Oracle. And I have come across a problem.
我是 Oracle 的新手。我遇到了一个问题。
Firstly,I want to check the privileges of the sysman account:
首先，我想检查 sysman 帐户的权限：
SQL> select * from dba_sys_privs where grantee='sysman';
no rows selected
I know that it means there is no content in my view dba_sys_privs. But anyway,I have aready built a database. So, I try again, just shortening the statement:
我知道这意味着我的视图 dba_sys_privs 中没有内容。但无论如何，我已经建立了一个数据库。所以，我再试一次，只是缩短了语句：
SQL> select * from dba_sys_privs
2
So here are my two questions:
所以这是我的两个问题：
- what happened to my database? I have already set up a database
- what does the "2" mean? Does it mean the next row or something else?
- 我的数据库怎么了？我已经建立了一个数据库
- “2”是什么意思？它是指下一行还是其他什么？
回答by APC
You have entered a new line character (pressed return) without entering a statement termination i.e. ;. Compare your second statement with the first one you posted. So yes, the 2means the client is awaiting further input.
您输入了一个新行字符（按下return）而没有输入语句终止，即;。将您的第二个声明与您发布的第一个声明进行比较。所以是的，这2意味着客户正在等待进一步的输入。
To run the second statement, simply enter a slash /
要运行第二个语句，只需输入一个斜杠 /
As for why your first statement returned no rows, in Oracle database object names (including users) are in upper-case.
至于为什么你的第一条语句没有返回任何行，在Oracle数据库中对象名称（包括用户）都是大写的。
select * from dba_sys_privs where grantee='SYSMAN';
