Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: what wrong with this statement?

Re: what wrong with this statement?

From: gazzag <gareth_at_jamms.org>
Date: 16 Mar 2006 03:31:49 -0800
Message-ID: <1142508708.950249.315810@u72g2000cwu.googlegroups.com> 





  1  select owner, count(*)


  2  from dba_objects


  3  group by owner


  4* having count(*) > 500


SQL> /



OWNER                            COUNT(*)
------------------------------ ----------
SCHEMA1                              501
SCHEMA2                         854
SCHEMA3                              613
ORDSYS                                969
PUBLIC                              11773
SYS                                 13685
XDB                                   605





7 rows selected.



SQL>

Received on Thu Mar 16 2006 - 05:31:49 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US