Hi,

I created a table called Temp in that i inserted 2 NULL Rows so now total rows is 8.
INSERT INTO TEMP VALUES(NULL,NULL);
When i executed SELECT COUNT(*) FROM TEMP giving Result as 8 it also counted 2 NULL Rows as per my knowledge COUNT ignores NULL Rows but in this case it considered NULL Rows.

can you Explain how is it possible?

with rws as (
  select rownum x from dual union all
  select null x from dual
)
  select count(*), count(x) from rws;

COUNT(*)  COUNT(X)  
2         1