In Oracle, it is quite well possible to display quickly how many non-nulls we have per column in a table.
The script reads like:
set termout off echo on feed off trimspool on head off pages 0 spool C:\countall.tmp SELECT 'select count('||t.column_name||') from ' || t.table_name ||';' FROM user_tab_columns t WHERE t.table_name = 'DATE_D2' ; spool off set termout on @@c:\countall.tmp set head on feed on
And the results look like: