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

Question

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.

Comments

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...

---

May be because dba_users is a system table.

http://www.java2s.com/Code/Oracle/System-Tables-Views/DisplayingtheAccountStatusofAllUsers.htm