top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Why select * from dba_users shows total number of rows selected but for normal table it won't shows the count of rows?

+2 votes
936 views

Its a very basic question but it would be good if anyone can answer with some explanations. When we type select * from dba_users; in sql plus it will show N rows selected and total records whereas when we type select * from employee it would show only records but not the total count.

posted Feb 21, 2017 by Chinmoy Padhi

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
To get the count use the count operator something like
select count(name) from employee...

Hope I understood the problem correctly.
Yes select count(*) will give the count for any table, if you check in sqlplus for example select * from dba_users; It will display the records and total number of rows selected whereas if you type select * from employee; it will display only records but not the total number of rows selected.
Now I got it...
Let some one from Oracle background respond to this I commented from MySQL point of view...

...