Re: what will a count return when ...

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