CODEWITHSUNDEEP
oracle-databaseoracle10goracle11gsqlplus
kaiwii ho
kaiwii ho

Reputation: 1407

what does the "2"mean in SQL*Plus?

I am new to Oracle. And I have come across a problem.

Firstly,I want to check the privileges of the sysman account:

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:

SQL>  select * from dba_sys_privs
  2

So here are my two questions:

  1. what happened to my database? I have already set up a database
  2. what does the "2" mean? Does it mean the next row or something else?

Upvotes: 24

Views: 25060

Answers (2)

Feng Zhang
Feng Zhang

Reputation: 1948

I encountered similar situaion due to my inserts did not work as expected. I used a insert statement followed by "commit;", it just says committed, but when I use sql developer to view the record, I could not find it. So I tried to run select from sqlplus and got a number. Later DBA told me to skip the "commit", then I could see the exception thrown.

Upvotes: 0

APC
APC

Reputation: 146239

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 2 means the client is awaiting further input.

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.

select * from dba_sys_privs where grantee='SYSMAN';

Upvotes: 32

Related Questions