sql query to count no of tables owned by each user in oracle database
SQL> SELECT COUNT(*), owner FROM ALL_TABLES group by owner;
COUNT(*) OWNER
---------- ------------------------------
39 WIN
39 REDON
121 PANK
3456 ANA
32 MONK
72 PAT
93 GREF
3456 CHIN
10 KILM
20 BLOG
155 SYSTEM
11 rows selected.
SELECT COUNT(*), owner FROM ALL_TABLES group by owner;
SQL> SELECT COUNT(*), owner FROM ALL_TABLES group by owner;
COUNT(*) OWNER
---------- ------------------------------
39 WIN
39 REDON
121 PANK
3456 ANA
32 MONK
72 PAT
93 GREF
3456 CHIN
10 KILM
20 BLOG
155 SYSTEM
11 rows selected.
No comments:
Post a Comment