统计当前用户下每个表的记录数

declare

v_count number(10);
t_count number(10) default 0;
cursor t_cur is
select table_name from user_tables;
begin
for t_rec in t_cur loop
execute immediate 'select count(*) from ' || t_rec.table_name into v_count;
dbms_output.put_line(to_char(t_rec.table_name));
dbms_output.put_line(to_char(v_count));
end loop;
end;

转载于:https://www.cnblogs.com/auldlangsynezh/p/7918800.html