declare
v_table varchar2(60);
v_num number;
begin
for idx in (select * from sys.user_tables) loop
v_table:=idx.table_name;
execute immediate 'select count(*) from ' || v_table into v_num ;
dbms_output.put(idx.table_name);
dbms_output.put(', ');
dbms_output.put_line(v_num);
end loop ;
end ;