Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T (ID INT, NAME VARCHAR2(20));
INSERT INTO T (ID) VALUES(1);
1 rows affected

select * from T;


ID
NAME


1
null


DECLARE
COUNT_COL INT;
SQL_STR VARCHAR2(100); 
begin
    For I in (SELECT OBJECT_NAME, COLUMN_NAME
              FROM USER_OBJECTS UO
              JOIN USER_TAB_COLS UTC ON UO.OBJECT_NAME = UTC.TABLE_NAME) loop

    SQL_STR := 'select count(1) from ' || I.OBJECT_NAME || ' where ' || i.column_name || ' is not null';

    Execute immediate SQL_STR INTO COUNT_COL;

    If COUNT_COL = 0 THEN
         DBMS_OUTPUT.PUT_LINE(I.COLUMN_NAME);
    End if;
End loop;
END;
/
1 rows affected

dbms_output:
NAME