Re: COUNT = 0

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 1995/08/15
Message-ID: <40ql4m$o3q_at_tpd.dsccc.com>#1/1


Amazing

I did a
SQL> select count (*) from dual where 1 = 2;  

COUNT(*)


       0  

SQL> I have no idea what your problem is.

Joanne Woytek (joanne_at_eosdev1.gsfc.nasa.gov) wrote:
:> I'd like to have a 0 appear from my sqlplus statement when count(*) is zero.
:> CUrrently it just shows a blank:
 

:> select count(*) from foo_table;
 

:> produces (assuming no rows in foo_table):
 

:> COUNT(*)
:> -------

:> What I would like is:
:> COUNT(*)
:> -------
:> 0
 

:> I feel like I must be missing something simple, but I can't find any thing in
:> the SQL manuals about this. Any suggestions?
 

:> Thanks
 

:> Joanne Woytek
:> joanne_at_daac.gsfc.nasa.gov

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.
Received on Tue Aug 15 1995 - 00:00:00 CEST

Original text of this message