Re: Count Function - Oracle 9i

"raghu" <raghu_vnin_at_yahoo.com> wrote in message news:1154732347.002557.261200_at_h48g2000cwc.googlegroups.com...
: 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 Received on Fri Aug 04 2006 - 19:44:50 CDT