declare
  v_count  pls_integer;
begin
  for r in (select table_name from user_tables) loop
    execute immediate 'select count(*) from ' || r.table_name into v_count;
    dbms_output.put_line( 'Table: ' || r.table_name || ', Count: ' || v_count);
  end loop;
end;
/