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 -> no rows selected vs. '0' count

no rows selected vs. '0' count

From: <oct1pm_at_hotmail.com>
Date: Thu, 30 Sep 1999 15:45:43 GMT
Message-ID: <7t00j3$5vi$1@nnrp1.deja.com>


Hi, can anyone help me solve this puzzle, please ?

The below query returns no rows.

  select count(*),AVG(DURATN),create_id from mcis_load_time   where to_char(strt_ts)='30-SEP-99' and create_id='1EQHBHAT'   group by create_id

no rows selected

If I remove the create_id from selection list. And also I remove the group by clause then the count(*) returns 0.

   select count(*),AVG(DURATN) from mcis_load_time    where to_char(strt_ts)='30-SEP-99' and create_id='1EQHBHAT'

 COUNT(*) AVG(DURATN)
--------- -----------

        0

Is there any way that I can force the first query to return some value so that I know that "no rows selected".

thanks,

Please email me also at: abhatt_at_shl.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 10:45:43 CDT

Original text of this message

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