title: Loop through multiple tables to execute same query
body: <p>I have a database wherein per day a table is created to log process instances.
  The tables are labeled MESSAGE_LOG_YYYYMMDD</p>
  
  <p>Currently I want to sequentially execute the same QUERY against all those tables.
  I wrote the PL/SQL below, but got stuck at line 10. How can I execute the SQL statement against successfully against all tables here? </p>
  
  <pre><code>DECLARE
    CURSOR all_tables IS
      SELECT table_name
              FROM all_tables 
              WHERE TABLE_NAME like 'MESSAGE_LOG_2%' 
              ORDER BY TABLE_NAME ;
  
  BEGIN
    FOR msglog IN all_tables LOOP
      SELECT count(*) FROM TABLE msglog.TABLE_NAME ;
    END LOOP;
  END;
  /
  </code></pre>