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 ;
if v_num>1 then
dbms_output.put_line(v_num||'====='||v_table);
end if;
end loop ;
end ;
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 ;
if v_num>1 then
dbms_output.put_line(v_num||'====='||v_table);
end if;
end loop ;
end ;