select sum(decode(a,null,1))+ sum(decode(b,null,1))+ sum(decode(c,null,1)

i have table T!.

A B C D
NULL 1 2 3
4 NULL 5 6
7 8 NULL 9
10 11 12 NULL.

I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

Question Posted / kishore vakiti

Answer Posted / kishore vakiti

select sum(decode(a,null,1))+
sum(decode(b,null,1))+
sum(decode(c,null,1))+
sum(decode(d,null,1)) tot_nulls from <TAB-NAME>;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you respond to dementia behavior?

971

what is single byte over head in oracle..?

2404

what is a relationship and what are they? : Sql dba

1101

Which sorts rows in sql?

1020

Which join is like inner join?

1027

How does one load ebcdic data? : aql loader

1175

Why do we use set serveroutput on?

965

Why schema is used in sql?

1049

Mention what does plv msg allows you to do?

1124

What are packages in pl sql and also explain its advantages?

1040

Is sqlexception checked or unchecked?

968

Why use truncate instead of delete?

1017

What are records give examples?

1010

Is inner join faster than left join?

1190

what is the difference between primary key and unique key? : Sql dba

1039