title: sql query to fetch all tables in a schema that was updated on sysdate
body: <p>need to write a sql query to fetch all tables in a schema 
  that was updated on sysdate.</p>
  
  <pre><code>select  distinct(table_name)
  from All_Tab_Columns 
  where owner = 'DBO' 
        and last_analyzed = sysdate;
  </code></pre>
  
  <p>It doesn't seem to work properly.</p>