Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Either it's equal or it isn't, right?
>SQL> select count(*) from phone;
>
> COUNT(*)
>----------
> 13042
>
>SQL> select count(*) from phone where record_status = 'A';
>
> COUNT(*)
>----------
> 12983
>
>
>>
> COUNT(*)
>----------
> 0
>
SQL> select count(*) from phone where record_status is null;
My guess is
COUNT(*)
NULL means 'not defined' or 'unknown' this means that any comparisson other than 'is null' will fail.
Rob Received on Wed May 06 1998 - 10:30:12 CDT