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

What is keys and its types?

1121

What is left join in sql?

1093

Why do we use view in sql?

1019

What are sql triggers used for?

1035

How to set up sql*plus output format in oracle?

1082

Why use stored procedures?

1140

Is full outer join same as cross join?

1016

What is cursor and why it is required?

1256

What is the usage of when clause in trigger?

1091

Is drop table faster than truncate?

1048

What is clause?

1229

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1034

Explain the uses of database trigger.

1175

How many databases can sql express handle?

1031

What is compute?

1151