create procedure pro as cursor t_sor is select table_name from user_tables; str varchar2(100); num number; begin for v_sor in t_sor loop str:='select count(1) from '||v_sor.table_name; execute immediate str into num; dbms_output.put_line(v_sor.table_name||' '||num); end loop; end; /
as
cursor t_sor is
select table_name from user_tables;
str varchar2(100);
num number;
begin
for v_sor in t_sor loop
str:='select count(1) from '||v_sor.table_name;
execute immediate str into num;
dbms_output.put_line(v_sor.table_name||' '||num);
end loop;
end;
/