select sum(nvl2(col1,0,1)+sum(nvl2(col2,0,1)+<...as many columns we hav

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 / ankesh

Answer Posted / ankesh

select sum(nvl2(col1,0,1)+sum(nvl2(col2,0,1)+<...as many
columns we have > from <table name>

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention what are the benefits of pl/sql packages?

1090

What is materialized view in sql?

926

How to connect a sql*plus session to an oracle server?

1136

Can delete statement be rollbacked?

992

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1013

What is sql query optimization?

1125

In a distributed database system, can we execute two queries simultaneously?

1100

How do I filter in sql profiler?

1003

What is a mutating table and a constraining table?

1122

What are the operators used in select statements?

1063

Can we use two order by clause in query?

975

What are basic techniques of indexing?

1391

Which join is like inner join?

1043

Can we insert data into view?

910

What is normalization in a database?

1168