title: How can I find columns which have non-null values?
body: <p>I have many columns in oracle database and some new are added with values.  I like to find out which columns have values other than 0 or null. So I am looking for column names for which some sort of useful values exists at least in one row.</p>
  
  <p>How do I do this?</p>
  
  <p>Update: This sounds very close. How do I modify this to suit my needs?</p>
  
  <pre><code>select column_name, nullable, num_distinct, num_nulls
  from all_tab_columns
  where table_name = 'SOME_TABLE'
  </code></pre>