title: NUM_NULLS and NUM_ROWS not work for Oracle
body: <p>I am trying to find the number of total rows, and the number of null rows for each column in a database. I feel like the following should work, but each time I run it the <code>num_nulls</code> and <code>num_rows</code> came back blank (So I put in the <code>COALESCE</code> so it now results in a 0)</p>
  
  <blockquote>
    <p>SELECT atc.column_name, atc.table_name, atc.data_type, COALESCE(atc.num_nulls, 0),  COALESCE(at.num_rows, 0)
    FROM
        all_tab_columns atc JOIN all_tables at ON ATC.TABLE_NAME = at.table_name ;</p>
  </blockquote>
  
  <p>Is there something wrong with my code or is it possible the <code>all_tab_columns</code> or <code>all_tables</code> are not up to date?</p>
  
  <p>PS. The tables do have information in them, I have already checked to see if the database was empty.</p>