Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: what will a count return when ...

Re: what will a count return when ...

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Wed, 27 Sep 2000 14:39:21 -0700
Message-ID: <8qtpe7$irf$1@spiney.sierra.com>

I hope you haven't been sitting there patiently waiting for someone to answer this question:

SQL> create table test (dummy number);

Table created.

SQL> select count(*) from test;

 COUNT(*)


        0

SQL> drop table test;

Table dropped.

SQL> "Steve ." <syarbrou_at_nospam.enteract.com> wrote in message news:onp4tsgs057me2135dcfh8qdlnbslvudch_at_4ax.com...
> Will a count(*) always return a value of some sort, even if it doesn't
> find anything? In other words, if the sql statement returns nothing,
> will the count be 0 or NULL or what? Thanks.
>
> Steve
Received on Wed Sep 27 2000 - 16:39:21 CDT

Original text of this message

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