How can I count only NULL values in Oracle/PLSQL? -


How can I count only the null values ​​in Oracle / PLSQL?

I only value null. Is there any such function?

I do not know Oracle specifically, but ANSI SQL, COUNT (line name) does not accept NULL value, but COUNT (*) then you <+++> 

  SELECT COUNT (*) from your column You can write where your column is Null

which calculates rows in your table, in which your column is set to zero. / P>


Comments

Post a Comment