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
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