babuda

 Profile Answers by babuda Questions by babuda

• Jul 13th, 2008

 

Someone need to confirm whether this is correct! Each owner is treated as schema(?),bang me if I am wrong

  1* select count(1),owner from all_tables group by owner
SQL> /

  COUNT(1) OWNER
---------- ------------------------------
         1 CTXSYS
        10 MDSYS
         8 SCOTT
        12 SYS
         2 SYSTEM
         5 WKSYS
         1 WMSYS

7 rows selected.

SQL>

babuda

 Profile Answers by babuda Questions by babuda

• Jul 13th, 2008

 

what abt this ?


  1* select sum(count(*)) from all_tables group by owner
SQL> /

SUM(COUNT(*))
-------------
           39

SQL>