Re: Oracle - Out of process memory

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Thu, 15 Aug 2002 07:58:15 GMT
Message-ID: <ajfn1a$gik$1@news1.xs4all.nl>

Johnny Yeung wrote:

>The SQL statement is:
>select distinct street_h, STREET_SEQ from building group by bldg_h,
>estate_h, street_h, district_e, area_e, STREET_SEQ having (1=1) and
>district_e = 'CHAI WAN' and area_e = 'HKG' ORDER BY STREET_SEQ;
>
>

Hello Johny,

this statement might be improved a lot from the following: select distinct

         street_h
,        STREET_SEQ
from     building  
where    district_e = 'CHAI WAN'
and      area_e     = 'HKG' 
group by bldg_h
,        estate_h
,        street_h
,        district_e
,        area_e
,        STREET_SEQ

ORDER BY STREET_SEQ; Kind Regards,

Herman de Boer
sr consultant
IT Consultancy Group bv Received on Thu Aug 15 2002 - 02:58:15 CDT