Re: COUNT = 0

From: Yee Lew <ylew_at_cc.weber.edu>
Date: 1995/08/15
Message-ID: <15AUG199512343590_at_cc.weber.edu>#1/1

In article <40qh10$i23_at_post.gsfc.nasa.gov>, joanne_at_daac.gsfc.nasa.gov (Joanne Woytek ) writes...
>I'd like to have a 0 appear from my sqlplus statement when count(*) is zero.
>CUrrently it just shows a blank:

I just tried it on a 7.1.4 RDBMS on a table with no rows and it returns a zero. Odd behavior you have, since I thought a COUNT(*) always returns a value. In your case, have you tried NVL(COUNT(*), 0)?

Regards,
Yee
Oracle consultant Received on Tue Aug 15 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Lance Hallgren: "Re: COUNT = 0"
Previous message: John Strange: "Re: COUNT = 0"
In reply to Joanne Woytek: "COUNT = 0"
Next in thread: Lance Hallgren: "Re: COUNT = 0"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message