How to Count Particular User in Oracle

You can see the output of this Queries. We need to type the usernames whose names are starting from Example : ACC


> Accountants = 77

> Engineers      = 402

> Managers      =   44


SQL> select count(*) from dba_users where username like 'ACC%';

  COUNT(*)
----------
        77

SQL> select count(*) from dba_users where username like 'ENGR%';

  COUNT(*)
----------
       402

SQL> select count(*) from dba_users where username like 'MGR%';

  COUNT(*)
----------
        44


Happy Learning...