Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count with NULL Values

SRI RAMOct 13 2010 — edited Oct 13 2010
hi all,

what is the behaviour of the count function when working with nulls.

I created a table name dummy of only one column name as serial, and inserted 4 nulls into it.

Now when i say count(*) the result is 4 and when is say count(serial) the result is 0. If count function ignores null then count(*) should also be 0.

can anyone explain the behaviour of count function with respect to table and column.....

thanks and regards,
sri ram.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2010
Added on Oct 13 2010
5 comments
2,512 views