declare
  cnt number;
begin
  for tab in (select table_name from my_table) loop
    execute immediate 'select count(*) from '||tab.table_name into cnt;
    dbms_output.put_line(tab.table_name||':'||cnt);
  end loop;
end;
/