When a column is defined as not null for a table, count(*) and
count(column) should return the same result. Correct?
However I am getting different results. What could be the reason?

Thanks.

"raghu" <raghu_vnin (AT) yahoo (DOT) com> wrote

: When a column is defined as not null for a table, count(*) and
: count(column) should return the same result. Correct?
: However I am getting different results. What could be the reason?
:
: Thanks.
:

the NOT NULL constraint could have been enabled with the NOVALIDATE option
(don't recall what version that was introduced) or be disabled -- but both
of these possibilities would be very unusual for a not null constraint

try select * where column is not null and see what you get

++ mcs