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:
