COUNT = 0

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 Received on Tue Aug 15 1995 - 00:00:00 CEST