Re: Help with select statement

Stan Towianski wrote:
<snip>
>
> select owner, segment_name, segment_type, count( extent_id )
> from dba_extents
> where ( owner like 'MANU%' or owner like 'ACCOUNT%' ) and count( extent_id ) >
> 20
> group by owner, segment_name, segment_type
> /
>

<snip>

select owner, segment_name, segment_type, count( extent_id ) from dba_extents
where ( owner like 'MANU%' or owner like 'ACCOUNT%' ) group by owner, segment_name, segment_type having count( extent_id ) > 20
/

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.