DECLARE
     v_count NUMBER;
     v_count1 NUMBER;
     v_stmt VARCHAR2(2000);
     v_stmt1 VARCHAR2(2000);
BEGIN
     FOR i IN (SELECT DISTINCT Table_Name FROM User_Tab_Columns) LOOP
         v_stmt := 'SELECT COUNT(*) FROM '||i.Table_Name ;
         EXECUTE IMMEDIATE v_stmt INTO v_count;
         FOR j IN (SELECT Column_Name FROM User_Tab_Columns WHERE Table_Name = i.Table_Name) LOOP
             v_stmt1 := 'SELECT COUNT(*) FROM '||i.Table_Name||' WHERE '||j.column_name||' IS NULL';
             EXECUTE IMMEDIATE v_stmt1 INTO v_count1;
     
             IF NVL(v_count, 0) = NVL(v_count1, 0) THEN
                DBMS_OUTPUT.PUT_LINE(i.Table_Name ||'   '||j.Column_Name);
             END IF;
     
         END LOOP;
     END LOOP;     
END;

SQL> DECLARE
  2       v_count NUMBER;
  3       v_count1 NUMBER;
  4       v_stmt VARCHAR2(2000);
  5       v_stmt1 VARCHAR2(2000);
  6  BEGIN
  7       FOR i IN (SELECT DISTINCT Table_Name FROM User_Tab_Columns) LOOP
  8           v_stmt := 'SELECT COUNT(*) FROM '||i.Table_Name ;
  9           EXECUTE IMMEDIATE v_stmt INTO v_count;
 10           FOR j IN (SELECT Column_Name FROM User_Tab_Columns WHERE Table_Name = i.Table_Name) LOOP
 11               v_stmt1 := 'SELECT COUNT(*) FROM '||i.Table_Name||' WHERE '||j.column_name||' IS NULL';
 12               EXECUTE IMMEDIATE v_stmt1 INTO v_count1;
 13       
 14               IF NVL(v_count, 0) = NVL(v_count1, 0) THEN
 15                  DBMS_OUTPUT.PUT_LINE(i.Table_Name ||'   '||j.Column_Name);
 16               END IF;
 17       
 18           END LOOP;
 19       END LOOP;     
 20  END;
 21  /
T1_ERR   ORA_ERR_TAG$
T2   COL
VALIDATE_STATS_RESULTS   INDEX_NAME
DECLARE
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
ORA-06512: at line 9

SQL> DECLARE
  2    v_count1 NUMBER;
  3    v_stmt1 VARCHAR2(2000);
  4  BEGIN
  5    FOR i IN (SELECT DISTINCT Table_Name FROM User_Tab_Columns) LOOP
  6      FOR j IN (SELECT Column_Name FROM User_Tab_Columns WHERE Table_Name = i.Table_Name) LOOP
  7        v_stmt1 := 
  8          'SELECT COUNT(*) FROM '||i.Table_Name||
  9          ' WHERE '||j.column_name||' IS NULL AND ROWNUM = 1';
 10        EXECUTE IMMEDIATE v_stmt1 INTO v_count1;
 11        IF v_count1 = 0 THEN
 12          DBMS_OUTPUT.PUT_LINE(rpad(i.Table_Name,30,'.')||' '||j.Column_Name);
 13        END IF;
 14      END LOOP;
 15    END LOOP;     
 16  END;
 17  /
T1_ERR........................ ORA_ERR_NUMBER$
T1_ERR........................ ORA_ERR_MESG$
T1_ERR........................ ORA_ERR_ROWID$
T1_ERR........................ ORA_ERR_OPTYP$
T1_ERR........................ ID
T1_ERR........................ VAL
T2............................ COL
VALIDATE_STATS_RESULTS........ TEST
VALIDATE_STATS_RESULTS........ TIMESTAMP
VALIDATE_STATS_RESULTS........ RESULT
EMP........................... HIREDATE
EMP........................... SAL
EMP........................... DEPTNO
EMP........................... EMPNO
EMP........................... ENAME
EMP........................... JOB
DECLARE
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
ORA-06512: at line 10

SQL> DECLARE
  2    v_count1 NUMBER;
  3    v_stmt1 VARCHAR2(2000);
  4    x_sql exception ;
  5    pragma exception_init(x_sql, -933);
  6  BEGIN
  7    FOR i IN (SELECT DISTINCT Table_Name FROM User_Tab_Columns) LOOP
  8      FOR j IN (SELECT Column_Name FROM User_Tab_Columns WHERE Table_Name = i.Table_Name) LOOP
  9        v_stmt1 := 
 10          'SELECT COUNT(*) FROM '||i.Table_Name||
 11          ' WHERE '||j.column_name||' IS NULL AND ROWNUM = 1';
 12        EXECUTE IMMEDIATE v_stmt1 INTO v_count1;
 13  --      IF v_count1 = 0 THEN
 14  --        DBMS_OUTPUT.PUT_LINE(rpad(i.Table_Name,30,'.')||' '||j.Column_Name);
 15  --      END IF;
 16      END LOOP;
 17    END LOOP;     
 18  EXCEPTION WHEN x_sql THEN dbms_output.put_line(v_stmt1); RAISE;
 19  END;
 20  /
SELECT COUNT(*) FROM BIN$dZy54p+ZRXu3c0vTces42g==$0 WHERE TEST IS NULL AND ROWNUM = 1
DECLARE
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
ORA-06512: at line 18

SQL> DECLARE
  2    v_count1 NUMBER;
  3    v_stmt1 VARCHAR2(2000);
  4    x_sql exception ;
  5    pragma exception_init(x_sql, -933);
  6  BEGIN
  7    FOR i IN (
  8      SELECT Table_Name FROM User_Tables
  9      minus
 10      SELECT object_name FROM recyclebin WHERE type = 'TABLE'
 11      ORDER BY 1
 12    ) LOOP
 13      FOR j IN (
 14        SELECT Column_Name FROM User_Tab_Columns 
 15        WHERE Table_Name = i.Table_Name
 16        ORDER BY column_id
 17      ) LOOP
 18        v_stmt1 := 
 19          'SELECT COUNT(*) FROM '||i.Table_Name||
 20          ' WHERE '||j.column_name||' IS NULL AND ROWNUM = 1';
 21        EXECUTE IMMEDIATE v_stmt1 INTO v_count1;
 22        IF v_count1 = 0 THEN
 23          DBMS_OUTPUT.PUT_LINE(rpad(i.Table_Name,30,'.')||' '||j.Column_Name);
 24        END IF;
 25      END LOOP;
 26    END LOOP;     
 27  EXCEPTION WHEN x_sql THEN dbms_output.put_line(v_stmt1);
 28  END;
 29  /
EMP........................... EMPNO
EMP........................... ENAME
EMP........................... JOB
EMP........................... HIREDATE
EMP........................... SAL
EMP........................... DEPTNO
T............................. COL
T1............................ ID
T1............................ VAL
T1_ERR........................ ORA_ERR_NUMBER$
T1_ERR........................ ORA_ERR_MESG$
T1_ERR........................ ORA_ERR_ROWID$
T1_ERR........................ ORA_ERR_OPTYP$
T1_ERR........................ ID
T1_ERR........................ VAL
T2............................ COL
VALIDATE_STATS_RESULTS........ TEST
VALIDATE_STATS_RESULTS........ TIMESTAMP
VALIDATE_STATS_RESULTS........ RESULT

PL/SQL procedure successfully completed.