oracle查询问题

Question

一张表有60个字段，如何查出这60个字段全部不为空的记录个数，小弟没思路，麻烦大家指点一下，谢谢

Answer 1

字段少的时候：
[code="sql"]select count(*) from tb where a is null and b is null[/code]

字段多的时候，：
[code="sql"]
DECLARE
TYPE myref IS REF CURSOR;
cur myref;
sqlStr VARCHAR2(200);
tb_name VARCHAR2(20);
TYPE arrays IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;
column_array arrays;
null_num INTEGER;
BEGIN
tb_name := 'TB';
sqlStr := 'SELECT column_name FROM user_tab_columns WHERE table_name = ''' ||
tb_name || '''';
OPEN cur FOR sqlStr;
FETCH cur BULK COLLECT
INTO column_array;
CLOSE cur;

sqlStr := 'SELECT COUNT(*) FROM ' || tb_name || ' WHERE 1=1';
FOR i IN column_array.FIRST .. column_array.LAST LOOP
    sqlStr := sqlStr || ' AND ' || column_array(i) || ' IS NULL ';
END LOOP;

EXECUTE IMMEDIATE sqlStr
    INTO null_num;
-- 都为空的记录数
dbms_output.put_line(null_num);

END;
[/code]